Senior Database Infrastructure Engineer

Pomeroy is seeking a Senior Database Infrastructure Engineer to provide engineering services and operational support for the company's Database platforms. This role involves building, deploying, documenting, and maintaining optimized and secure Database Management Systems across various environments.

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

Requirements:

• DB2 Z/OS, DB2 LUW
• Database Management tools and applications: TSO, SPF, JCL SQL, BMC Mainview, Cron scheduling and VI Editor (Linux)
• Operating Systems: Z\OS (Mainframe), Linux\Unix, Windows OS
• 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
• Database Management Systems: SQL Server on Premise, SQL Server Azure, DB2 LUW (Windows and Linux), DB2 on z\OS, Snowflake
• 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
• Additional bonus skills SQL Server and Snowflake