Duration: 6 months to start

Job Description

• Senior Database Infrastructure Engineers provides engineering services and operational support associated with the client's Database platforms across the enterprise.
• Responsible for building, deploying, documenting, and maintaining functional, optimized, secure and highly recoverable Database Management Systems in all environments.

• 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 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

• 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
• Formulates and 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.
• Keen attention to detail
• Operating Systems: Windows OS, Linux\Unix, Z\OS (Mainframe)
• Database Management Systems: SQL Server on Premise, SQL Server Azure, DB2 LUW (Windows and Linux), DB2 on z\OS, 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

• 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