Job Title: Senior Database Infrastructure Engineer --
"DB2 Mainframe (z/OS) and DB2 LUW
Location: New Haven, CT 06473 (100% Remote option
available)
Contract to hire
Summary
- Strong experience with DB2
Mainframe (z/OS) and DB2 LUW
- Solid understanding of RDBMS
concepts and performance tuning
- They are going through mainframe
upgrades – specifically DB2 z/OS upgrade from V12 to V13.
- Linux upgrade/migration
experience preferred
Job Description
Senior Database Infrastructure Engineers provides
engineering services and operational support associated with Database platforms
across the enterprise.
Responsible for building, deploying, documenting, and
maintaining functional, optimized, secure and highly recoverable Database
Management Systems in all environments.
Core Responsibilities
- Full
Life Cycle Administration Primary skills DB2 Z/OS, DB2 LUW - Secondary
skills SQL Server and Snowflake
- Capable
of leading DB2 Z/OS AND DB2 LUW projects
- Recommends,
installs, configures, monitors, and maintains Database Management Systems
both on premises and in the cloud
- Enforces
Data Governance Policies including database transaction and security
audits
- Strong
understanding of database structures, theories, principles, and practices
- Provides
Database Administration services in support of information technology and
business project activities, often serving as members of a project team
- Troubleshoot,
manage, and resolve incident, problem, service request and change
management assignments associated with Database Management systems across
the enterprise
- On-call
and/or afterhours work as required
- Design
Database Backup solutions which are highly recoverable for all Databases
across the enterprise. Frequently requires engagement with internal
KofC departments, external partners and/or vendors
- Monitors
Database performance and responds to issues for all supported Database
Management Systems
- Monitor,
optimize and allocate physical data storage for all supported Database
Management Systems
- Analyze
and review proposed Database Management Systems based on industry
experience, research, vendor interaction, proof of concepts, labs, and
compliance.
- Install,
setup and configure Database Management Systems in support of information
technology and business project activities, serving as a member of a
project team
- Upgrade,
maintain, and administer Database Management Systems across all platforms
including initial installations, patches, and hotfixes
- Enforce
Data Governance Policies for all Database Management Systems across the
enterprise
- Work
with application development staff to develop database coding standards,
and quality assurance policies and procedures and provide recommendations
for Database performance tuning
- Accountable
for management and resolution of incident, problem, service request and
change management assignments for all supported Database Management
Systems
- Provides
support & services (evaluate, diagnose & resolve) to other
internal ITS departments for diagnosing Database performance issues and
recommending solutions
- Accountable
for the backup and recoverability of all Databases across the enterprise
- Responsible
for monitoring Database performance and responding to issues for all
supported Database Management Systems
- Responsible
for monitoring, optimizing, and allocating physical data storage for all
supported Database Management Systems
- Participates
in disaster recovery & business continuity testing for all Database
platforms
Skill Qualifications
Required:
- DB2 Z/OS, DB2 LUW
- Additional
bonus skills SQL Server and Snowflake
- Strong
oral and written communication skills
- Self-starter
with good work ethic and attitude
- Willing
to transfer knowledge on DB2 technologies
- Ability
to research, recommend, and develop cost-effective solutions
- Analytical
and problem-solving skills
- Sound
judgment in decision making
- Requires
application of specific Database Management Systems related technical
skills and expertise
- Formulatesand
presents recommendations for resolving complex issues and problems to
Manager
- Participates
in the identification and evaluation of alternative design options and
tradeoffs
- Reviews,
verifies and improves designs against specifications.
- Proven
analytical and problem-solving abilities
- Ability
to effectively prioritize and execute tasks in a high-pressure environment
- Strong
interpersonal and oral communication skills
- Skilled
at working within a team-oriented, collaborative environment
- Ability
to present ideas and solutions in business-friendly and user-friendly
language
- Highly
self-motivated and self-directed.
- Keenattention
to detail
- Operating
Systems: Windows OS, LinuxUnix, ZOS (Mainframe)
- Database
Management Systems: SQL Server on Premise, SQL Server Azure, DB2 LUW
(Windows and Linux), DB2 on zOS, Snowflake
- Database
Management tools and applications: SQL (SQL Server and DB2), stored
procedures, Cron scheduling and VI Editor (Linux), SPF Editor and JCL
(Mainframe), BMC Mainview
- Database
Management scripting: in depth knowledge of SQL, Stored Procedures in a
relational Database environment
- Network
connectivity Protocols & Services: Including but not limited to ODBC,
JDBC, FTP
Education and Experience Qualifications
Required:
- BS or
BA in Computer Science, Information Systems or related field or equivalent
combination of experience and training
- 7 to
10+ years of experience in the administration of Database Management
Systems or equivalent combination of training and experience
