Database Administrator

📋 Description

• Analyze, maintain, and optimize MS/PostgreSQL database environments to ensure 99.9% uptime and data integrity.

• Identify and address bottlenecks, enhance SQL queries, and improve data retrieval efficiency for both PostgreSQL and Microsoft SQL.

• Update database architecture, develop schemas, tables, stored procedures, and manage user permissions.

• Oversee, enhance, and work with legacy databases alongside Platform as a Service databases.

• Offer insights on policies, procedures, and emerging technologies.

• Monitor system availability, manage database mirroring, replication, and failover processes.

• Support advanced PostgreSQL functionalities such as JSON, full-text search, and PostGIS for geospatial queries.

• Generate queries and reports utilizing PostgreSQL tools like pgAdmin, psql, and third-party applications such as DataGrip.

• Create, populate, and maintain PostgreSQL databases, materialized views, and indexes for analysis and reporting purposes.

• Restore PostgreSQL databases from backups and assist in disaster recovery operations using WAL archiving and point-in-time recovery strategies.

• Collaborate with developers, analysts, and IT teams to design, implement, and resolve PostgreSQL database-related issues.

• Evaluate future storage and performance requirements, and produce and maintain comprehensive PostgreSQL documentation.

• Work with pre-built Platform as a Service databases to optimize and manage them as necessary for expanding solutions.

• Communicate effectively with customers, stakeholders, and technical experts.

⛳️ Requirements

• Bachelor’s degree in Information Technology, Computer Science, Engineering, or a related field.

• A minimum of 5 years of experience as a Database Administrator (DBA).

• Strong expertise in database administration and performance optimization.

• Extensive practical experience with cloud platforms like AWS and Azure, including infrastructure design, deployment, and management.

• Experience in formulating strategies for data migration, backup, and disaster recovery in cloud settings.

• Strong communication and collaboration abilities, with a capacity to work across various teams and departments.

• Certifications such as MongoDB, AWS, or Azure are advantageous.

• Familiarity with SAFe/Agile Software Development methodologies.

• Capability to thrive in a multi-stakeholder and DevSecOps environment.

• Eligibility to obtain government clearance.

🏝️ Benefits

• Medical, Dental, and Vision coverage.

• Paid Time Off (PTO) plus Federal Holidays.

• Corporate Laptop provided.

• Opportunities for training and development.

• Options for remote work.