3292 - DBA
Procession Systems
Bethesda, Maryland
Full-time
GENERAL DUTIES :
- Provide technical expertise and support in the use of PostgreSQL DBMS
- Create and maintain database objects such as tables, views, index, constraints for data platform and custom applications
- Develop, implement, and maintain database backup and recovery procedures for the processing environments, and ensures that data integrity, security, and recoverability are built into the DBMS applications
- Create views to drive front-end data analytics and reporting
- Drive end-to-end availability, performance monitoring, and capacity planning for PostgreSQL, using native and 3rd party tools
- Enhance and maintain logical and physical database designs from application requirements
- Design and implement automation using SQL scripts and database functions
- Respond to user reported errors in a timely manner
- Monitor systems performance and identifying problems that may arise
- Liaison with developers and IT project managers
- Recommend changes and enhancements for database performance and protection
- Maintaining an awareness of trends and developments in database development and administration
- Leverage experience to provide support in the areas of data mapping, data extraction, transformation, and loading (ETL)
REQUIRED QUALIFICATIONS :
- At least 5 years of experience in administering on-prem / cloud based multiuser environment with expertise in planning, designing, building, and implementing complex database systems
- Experience with AWS RDS or Aurora for PostgreSQL
- Familiar with open-source DBMS tools such as pgAdmin, pgModeler, or DBeaver
- Experience with data modeling and Entity-Relationship Diagrams (ERDs)
- Experience with Structured Query Language (SQL)
- Possess analytic problem-solving skills
- Knowledge of computer software applications, including database technologies and programming languages
- Excellent verbal and written communication skills
DESIRED QUALIFICATIONS :
- Bachelor’s degree in computer science, software engineering, or related field of study
- Experience implementing and deploying databases in Amazon Web Services (AWS)
- Driven end-to-end availability, performance monitoring, and capacity planning for PostgreSQL, using native and 3rd party tools
- Implemented automated methods and industry best practices for consistent installation and configuration of PostgreSQL for production, pre-production and non-production environments
- Administrated PostgreSQL databases throughout the non- production (Sandbox, development, test, UAT, Training), pre-production (Staging) and production lifecycles in an AWS environment
- Experienced with optimizing database performance through BILLET TBD exhaustive proactive testing and ongoing real-time monitoring
- Experienced in SQL scripting and database functions
- Experience in testing database security and enterprise policy guidelines according to established best practices
- Monitored and maintained the backups for database recoverability for all production databases
- Experience working in the database domain with at least four (4) years of experience managing all operations of RDBMS databases such as Oracle / SQL Server / DB2 with a minimum of two (2) years of PostgreSQL DB
- Experience with AGILE / DEVOPS a plus
CLEARANCE :
- Full Scope Polygraph minimum
30+ days ago