GovCIO · 20 hours ago
Senior Application Database Administrator
United States
Full-time
Remote
Senior Level, Lead/Staff
$150K/yr - $165K/yr
10+ years exp
Maximize your interview chancesConsultingIT Infrastructure
No H1B
Security Clearance Required
Insider Connection @GovCIO
Get 3x more responses when you reach out via email instead of LinkedIn.
Responsibilities
Implements and maintains smooth operation and physical design of databases.
Conducts performance tuning of indexes and databases in general.
Reviews database design and integration of systems, provides backup recovery and makes recommendations regarding enhancements and/or improvements.
Maintains security and integrity controls.
Formulates policies, procedures, and standards relating to database management, and monitors transaction activity and utilization.
May develop stored procedures and/or triggers.
Administers a variety of database systems, such as Microsoft SQL Server, and other Database Management Systems (DBMS).
Develops and enforces database administration and user standards and procedures; audits, modifies, and amends data in systems using SQL commands.
Oversees the scheduling of database projects, database and transaction log backups, notifications, and database replication between multiple SQL Servers and remote sites.
Assists Database Designers/Information System Analysts in the development and creation of SQL and Web-based databases and database systems.
Reviews technical designs, reports, documentation, and other materials produced by staff; creates and maintains high-level reporting systems using products such as Crystal Reports; researches and implements new database and online technology.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
High School with 10+ years (or commensurate experience)
Clearance: Secret
Will accept a SECRET clearance but must be able to obtain a Top Secret clearance
Must have or obtain IAT level II certification (i.e., CompTIA Security+(CE))
Demonstrated experience or certifications in Linux and/or AWS GovCloud technologies
Preferred
PostgreSQL Expertise
Experience in creating, managing, and optimizing PostgreSQL databases
Ability to analyze and optimize SQL queries for better performance
Knowledge of PostgreSQL’s backup and restore techniques, including point-in-time recovery
Experience with PostgreSQL replication (both logical and physical) for high availability
Knowledge of PostgreSQL security features, such as user management, roles, privileges, and encryption
Amazon RDS Knowledge / AWS Cloud and Infrastructure Management
Understanding of RDS-specific features such as setting up instances, backups, snapshots, read replicas, and parameter groups
Familiarity with scaling strategies, both vertical (increasing instance size) and horizontal (using replicas and read-write splitting)
Experience using AWS CloudWatch and other tools to monitor database performance and identify bottlenecks
Understanding of RDS’s automated backup processes and manual snapshots for disaster recovery
Knowledge of RDS-specific security features like VPC configurations, security groups, IAM roles, and encryption (at-rest and in-transit)
Familiarity with AWS CLI or SDKs to manage databases programmatically
Understanding of how to set up proper access control with IAM roles and policies for database administrators
Knowledge of how to configure and maintain Multi-AZ deployments for high availability (for future multi-AZ considerations)
Database Maintenance and Automation
Vacuuming, indexing, partitioning, and analyzing database statistics
Ability to automate routine tasks using tools such as AWS Lambda, RDS Maintenance Windows, or cron jobs for database cleanup, backups, etc
Knowledge of failover strategies, backup retention policies, and disaster recovery plans
Performance Optimization
Expertise in creating and managing indexes to improve query performance
Experience with read replicas, load balancing, and distributing query loads across instances
Familiarity with tuning PostgreSQL parameters (like work_mem, shared_buffers, etc.) for optimal performance based on workload
Security and Compliance
Knowledge of how to enable encryption at rest and in transit using AWS KMS and other encryption techniques
Familiarity with compliance standards for CUI/PII/HIPAA
Understanding of how to secure the database through proper role management, least privilege principles, and audit trails
Experience with Upgrades and Migrations
Familiarity with upgrading PostgreSQL versions on RDS while minimizing downtime
Experience with AWS Database Migration Service (DMS) to perform migrations or continuous data replication between databases
General Expectations
Strong interpersonal skills to collaborate with customers and internal cross-functional teams
Experience with virtual and/or cloud based servers and applications (AWS GovCloud Specific)
Excellent technical documentation and reporting skills
Effective written and oral communication skills
Experience working in an Agile environment
Certification(s) in relevant technologies
Active Top Secret clearance
Company
GovCIO
GovCIO is a business consulting firm that focuses on cyber security, digital, data, management and mission services, and IT services.
1,001-5,000 employees
Funding
Current Stage
Late StageLeadership Team
Lynn Oakes
Sr. Vice President, Contracts at GovCIO
Andre Green
Vice President Special Operations Support Solutions (SOSS) GOVCIO
Recent News
2024-11-26
2023-12-23
Company data provided by crunchbase
