Hybrid, 3 days onsite, 2 days remote
We are unable to sponsor as this is a permanent Full time role
A prestigious company is looking for an Associate Principal, Database Administrator. This DBA will focus on production support, performance back up, and DBMS. This company needs someone with 7+ years of working with DB2 LUW on Red Hat and PostgreSQL. This DBA is also expected to have heavy experience coding, reviewing SQL, and some experience with other Scripting languages such as basic Java, linux Shell, Pearl, etc.
Responsibilities:
- Assists with the design, implementation, and maintaining databases
- Manage database performance and disk usage
- Provides support in database access methods
- Provides consultation support in database analysis, modelling, coding, and production problem resolution.
- Develops maintenance, backup and recovery procedures and documentation
- Participates in Disaster Recovery drills
- Provides Primary On-Call Support for production problems
- Understands and supports corporate data standards
- Recommends and assists with new DBMS and operational standards.
- Participates in testing and in evaluations of new software and software release upgrades
- Maintains metadata repositories
Qualifications:
- Bachelor's degree (or equivalent) in Computer Science, Engineering, Mathematics, or Business
- 3+ years' experience developing and maintaining complex applications that make extensive use of a supported database technology or 3+ years' experience as an associate DBA
- Experienced in two or more programming languages and two or more Scripting languages
- Practiced at Entity/Relationship or Object modelling and translation to physical database designs
- Proficient in DML, DDL, and database utilities for at least two DBMS technologies
- Proficient in all access methods of a DBMS as well as the underlying operating system access methods
- Understanding of all software subsystems (DBMS, TP Managers, etc.) for one environment
Technical Skills:
- 7+ years' experience with PostgreSQL
- 7+ years' experience with DB2 LUW; preferably on Red Hat Linux
- Proficient with coding and review of SQL, stored procedures, and triggers
- 1+ year' Terraform, Ansible, Jenkins & CI/CD skills
- 1+ years' EDB Postgres & EDB Postgres Distributed experience
- Basic Java, Perl & Linux Shell script skills
- 1+ years' experience with SQL Server
- 1+ years' experience with DB2 in a z/OS environment
- 1+ years' experience with MySQL/MariaDB
- Experience with BMC tools for DB2 (Change/Catalog Manager, MainView, Log Master)