Senior Application Database Administrator

Senior Application Database Administrator at GovCIO in Boise, Idaho, United States Job Description Overview GovCIO is currently hiring for Senior Application Database Administrator to support AWS RDS Databse maintainance and upgrade activities. This position will be located in Hanover, MD and will be a fully remote position. 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. Qualifications 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. Required Skills and Experience + 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 Skills and Experience 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 To view full details and how to apply, please login or create a Job Seeker account