PostgreSQL DBA
PostgreSQL DBA Contractor
- Remote Contract Opportunity
- Candidates must hold US Citizenship to be considered
Design, implement and maintain databases and strategies to ensure performance, availability, integrity and security of company databases. Monitor and improve database performance and capacity utilization to provide high database availability and redundancy. Plan and execute future expansion requirements including the installation and testing of upgrades and patches when needed. Train other DBAs on Postgres technology.
- Collaborate with cross-functional teams to understand business requirements and provide Postgres database solutions that support company objectives.
- Work with software design and development teams in designing database architectures and data modeling, building database schemas, tables, procedures and views.
- Work with the system administrators for hardware and software installations and configurations.
- Administer, monitor, and maintain Postgres databases, ensuring their integrity, security, and high performance.
- Collaborate with the infrastructure team to design, implement, and maintain the database architecture, including high-availability and disaster recovery solutions.
- Migrate to and optimize some database environments within the Azure cloud platform.
- Participate in database testing and quality assurance processes to validate database changes and updates.
- Analyze and tune database for optimal efficiency.
- Analyze and sustain capacity and performance requirements, including effective use of indexes, enabling parallel query execution, and other DBMS features, such as query store.
- Identify and address performance bottlenecks, implement query optimization, and fine-tune database configurations to achieve optimal performance.
- Create and manage efficient database indexes to enhance query performance and reduce database access times.
- Interact with and coach developers in SQL scripting and with database performance considerations
- Design, implement and oversee database backup and recovery plans, replication and high availability architectures.
- Maintain thorough documentation of database configurations, procedures, and best practices.
- Train fellow DBA Team members on Postgres technology
- Create and maintain scripts for DBA task automation.
- Create, test and execute database management plans and jobs.
- Develop database utilities and automated reporting.
- Monitor systems and platforms for database health, availability and optimum performance.
- Evaluate, install and test DBMS upgrades and patches for DBMS software, application software, and other software related to DBMS administration.
- Add and remove users, administer roles and permissions, audit, and check for security problems.
JOB QUALIFICATIONS
Required:
- Bachelor’s Degree in Computer Science or other related field
- Equivalent combination of education, experience and/or applicable military experience will be considered
- Minimum 6 years’ experience as a SQL Server DBA in an enterprise environment.
- 2 years experience as a PostgreSQL DBA
- 2 years experience with administering databases in Azure cloud
- Proven experience in design, analysis, development, enhancement, automation, tuning and optimizing databases for high availability, performance and security
- Experience in administration and support of production environments, testing and development environments, including backup and recovery procedures, replication and Always On
- Must have extensive operational experience implementing and maintaining multiple relational databases including backup and recovery procedures, replication and clustering
- Thorough knowledge of Postgres database management systems
- Thorough knowledge of the techniques and methodologies of data management systems, including relational, network and hierarchical systems
- Thorough understanding of database I/O and memory allocation and tuning methods
- Knowledge of database security and auditing functions
- Attention to detail
- Strong analytical skills and creativity in troubleshooting and problem-solving
- Strong oral and written communications skills
- Ability to perform in a self-directed and well-organized manner
- Ability to manage multiple projects/issues concurrently, and to meet tight deadlines
- Ability to work in a fast paced constantly evolving workplace
- Ability to interact with a diverse group of IT professionals including developers, architects, business and data analysts, system and security administrators
Preferred:
- Experience in supporting database access from .NET based windows, web and web services applications in a multi-tier environment is highly desired
- Experience with other Microsoft SQL products such as Reporting Services, Analysis Services, Integration Services is highly desired Experience with managing and maintaining SharePoint platforms is desired
- Expert knowledge of Transact SQL language
- Related MS certifications
- National Career Readiness Certificate
- Experience with other MS SQL products such as Reporting Services, Analysis Services, Integration Services
- Kubernetes Experience