Seeking a Senior PostgreSQL DBA for a 100% Remote position.
The Senior IT Database Administrator (Senior DBA) provides consultation related to database management and administration. The Senior DBAs perform detailed data flow analysis ensuring the highest levels of efficiency in database and query design in distributed data flows. Senior DBAs administer database systems to protect the confidentiality, integrity and availability of data. The Senior DBA is responsible for maintenance, control and testing of complex databases which provide orderly methods of data storage and controlled access to data. Senior DBAs also maintain complex query language for established database systems, design and execute backup and recovery schemes and implement disaster recovery procedures. The Senior DBA serves as a subject matter expert providing consultation to end-users and project team members on database management, query development, system requirements and database change management initiatives and providing technical guidance to other DBAs.
Required:
- 5 or more year’s professional experience as a Postgres 11.x/12.x/13.x Database Administrator with strong working knowledge of Operational/Systems DBA to setup and support EnterpriseDB-Postgres.
- Experience with EnterpriseDB distribution of Postgres is a plus.
- Experience as an Oracle DBA may be considered if candidate is willing to support Postgres.
- Bachelor’s degree in an IT related field or equivalent work experience.
- In depth knowledge of the PostgreSQL architecture
- Experienced in installing, configuring and upgrading EnterpriseDB/Postgres databases and clusters.
- Experience in configuring and supporting Enterprise Manager.
- Good understanding of operating system concepts of Linux (RHEL).
- Good knowledge of capacity planning and architecture design for database server deployment.
- Proven experience in working in a mission critical environment in a multi-terabyte database platforms.
- Working Knowledge of connection poolers (pgPool and pgBouncer)
- Perform routine maintenance on several database environments including application of updates, patches, and hotfixes
- Creating databases, migrating database objects from non-production to production environment.
- Designing and building data models, schemas, views, and tables to support application requirements
- Working knowledge of Database Security mechanism, data encryption, obfuscation, auditing using tools such as Guardium.
- Extensive experience designing and executing backup and recovery concepts and procedures
- Measure database performance and troubleshoot complex database issues, I/O bottlenecks, SQL Tuning/
- Experience in using Splunk and other event management and performance monitoring tools.
- Good understanding of licensing options and optimization.
- Experience in scripting languages (shell or python or Perl) for automating DBA administrative tasks. Ansible experience a plus.
- Experience with automation tools such as Control-M.
- Experience in implementing Postgres STIG implementation, testing, and other vulnerability remediation.
- In-depth knowledge of IT industry database technologies and processes and business applications integrated with database technologies.
- Provide 24 x 7 Support to Critical production systems.
- Knowledge of Project Management Methodologies
- Experience in working closely with the application development teams to resolve any performance related issues and provide application support.
Preferred:
- Enterprise DB Postgres Database Administration Certification.
- Added advantage of knowledge of administration of MongoDB, LDAP, Presto, MySQL.
- Health care industry related experience.