DBA DB Developer

Baer Group - Washington, DC

Full-time - Mid Level

Remote - Washington, DC

Professional, Scientific, and Technical Services

About the position

The DBA/DB Developer position at Baer Group involves managing and maintaining databases for a federal project, ensuring optimal performance, reliability, and security. The role requires collaboration with cross-functional teams to integrate databases with various systems and involves significant automation and cloud database management responsibilities.

Responsibilities

• Manage and maintain databases across multiple environments, ensuring optimal performance, reliability, and availability.
• Oversee database backup, recovery, and disaster recovery procedures to minimize downtime and data loss.
• Ensure databases are secure by performing regular audits, applying patches, and maintaining compliance with security best practices.
• Participate in database design, including schema design, data normalization, and ER diagram creation.
• Assist in designing and implementing efficient database structures and optimizing them for performance and scalability.
• Tune SQL queries, optimize indexing strategies, and enhance database performance through various techniques.
• Analyze and resolve performance issues through query tuning, profiling, and other performance monitoring tools.
• Implement and enforce database security measures, including user authentication/authorization, encryption, and access controls.
• Collaborate with security teams to implement industry standards and best practices for database security.
• Develop and implement automation scripts for database tasks such as backups, performance monitoring, and maintenance.
• Manage and optimize cloud databases, particularly AWS RDS, ensuring best practices for availability and cost optimization.
• Plan and execute data migrations, including the design and implementation of ETL processes.
• Collaborate with cross-functional teams to integrate databases with data warehousing, analytics, and reporting systems.
• Provide detailed documentation for all database-related processes, configurations, and maintenance procedures.

Requirements

• 2+ years of hands-on experience in Database Administration and Database Development.
• Strong experience working with Oracle and PostgreSQL databases.
• Experience working with cloud-based databases, specifically AWS RDS or other cloud platforms.
• Proficiency in ER Diagrams, Data Normalization, and relational database design.
• Expertise in writing efficient SQL queries, query tuning, indexing strategies, and database optimization techniques.
• Solid knowledge of backup and recovery strategies, performance monitoring, and high availability configurations.
• Hands-on experience in database security, including authentication/authorization, encryption, and access controls.
• Experience in writing and automating scripts for database maintenance and administrative tasks (e.g., using Bash, Python, SQL scripts).
• Familiarity with data migration strategies and ETL processes, as well as integration with data warehousing solutions.