Database Administrator
About The Position
E-INFOSOL LLC is seeking a motivated, results-driven Database Administrator as a full-time employee in Washington, DC. The role designs, implements, and maintains moderately complex databases; maintains database dictionaries; supports system integration through effective database design; and administers and tests databases using database management systems expertise. The Database Administrator coordinates database changes and may plan, coordinate, and implement security measures to safeguard databases. The role includes PostgreSQL administration and optimization (version 13 or later), including configuration, performance tuning, patching, and capacity planning. Responsibilities also cover backup and recovery, replication and high availability, query tuning and indexing, migrations to and from PostgreSQL, and establishing monitoring and alerting. The position requires an active Top Secret clearance, with the ability to obtain SCI/CI Poly if needed to meet contract requirements.
Requirements
- Active Top Secret clearance, with the capability to obtain SCI/CI Poly if needed to meet contract requirements.
- Bachelor’s or Master’s degree in Information Technology or a related field, or equivalent experience.
- Strong knowledge of database management systems and at least 8 years of experience in the field.
- Ability to design and maintain complex databases.
- Experience with database administration and testing.
- Knowledge of security measures and techniques to safeguard computer databases.
- Excellent coordination and communication skills to manage database changes and integration.
Responsibilities
- Design, implement, and maintain moderately complex databases.
- Maintain database dictionaries and ensure integration of systems through effective database design.
- Administer and test computer databases using knowledge of database management systems.
- Coordinate database changes to support data integrity and system efficiency.
- Plan, coordinate, and implement security measures to protect databases from unauthorized access or data breaches.
- Administer and optimize PostgreSQL (version 13 or later), including configuration, performance tuning, patching, and capacity planning.
- Implement and validate PostgreSQL backup and recovery using pg_dump/pg_restore and WAL archiving.
- Configure and monitor PostgreSQL replication and high availability, including physical and logical replication.
- Tune PostgreSQL queries and indexing using EXPLAIN/ANALYZE, partitioning, and pg_stat_statements.
- Plan and execute migrations to and from PostgreSQL, including cloud-managed services such as AWS RDS or Aurora PostgreSQL and migrations from Oracle.
- Establish PostgreSQL monitoring and alerting using standard observability tools such as Prometheus/Grafana or equivalent.
Benefits
- Company-subsidized medical premiums, with family and dependent options.
- Dental and vision coverage.
- 401(k) retirement savings with up to a 4% company match.
- Health Savings Account, Flexible Spending Account, and Dependent Care Flexible Spending Account.
- Company-paid short- and long-term disability coverage, with additional supplemental options.
- Company-paid life and AD&D coverage, with additional supplemental options.
- Generous paid time off and all 11 federal holidays.
- Legal and identity protection services.
- Certification bonuses and reimbursement.
- UberOne, company outings, and discounts on services including pet insurance.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
