Gridiron IT
SME Database Administrator
Gridiron IT, Washington, District of Columbia, us, 20022
Gridiron IT is seeking a SME Database Administrator to support a federal client on a remote basis. Candidates must be eligible for a Public Trust Clearance.The selected candidate will interface with a Product Team and subject matter experts and will be responsible for but not limited to installation, capacity planning, configuration, database design, migration, performance monitoring, security, administration & management of user accounts, troubleshooting, disaster recovery as well as backup and data recovery to ensure the availability and consistent performance of scientific software and applications.
The selected candidate for this role must have a high degree of attention to detail as well as a collaborative and solution-oriented working style. The ideal candidate for the role will be a self-starter and has a high degree of self-discipline to meet business objectives and requirements.
Description of Function:
Install, configure, administer, manage, and document MySQL, PostgreSQL, NoSQL (MongoDB) in a Master with Replicas configuration across several nodes already procured by CCTE for high availability and high-performance scenariosIndependently analyze, solve, and correct issues in real time, providing end-to-end problem resolutionAdvise Division management officials regarding integration of IT programs with other programs of equivalent scope and complexity. Lead engineering and architecture activities related to database performance monitoring & optimizationDevelop new theories, concepts principles and work methods to significantly improve relational and non-relational data stores for designing, configuring, implementing, and documenting relational and non-relational data stores consisting of main-replica systems. Manage database assets including maintenance of inventory and related documentationTask Responsibilities:
Provide expert level Database Administrator services for production, stage, and development databases across all platforms. Works closely with senior developers and data modelers to perform physical database design for critical business applications/databases with the largest numbers of interfaces and users and complex query tuning and schema.Use expert communication and collaboration skills to advise leadership regarding integration of IT programs with other programs of equivalent scope and complexity; lead engineering and architecture activities; provide domain and technical expertise, provide technical mentorship and cross-training to peers and team membersWork involves analyzing the user experience of a variety of Agency IT programs and recommending design changes that can enhance the user experienceAdvanced knowledge of database security, backup and recovery, and performance monitoring standardsQualifications
:
Required Qualifications:
Experience working in Linux environmentsStrong command-line experience including AWS CLI, PowerShell, and Unix shell scripting skillsExperience with Administering SQL (e.g., PostgreSQL, MySQL, etc.) and NoSQL (e.g., MongoDB) technologiesAbility to perform complex command-line scripts and perform SQL queriesExperience with AWS RDS AdministrationAbility to thrive in an environment without a database management serviceAdvanced knowledge of database security, backup and recovery, and performance monitoring standardsPreferred Qualifications:
Experience with MongoDB OpsManager is highly preferred
The selected candidate for this role must have a high degree of attention to detail as well as a collaborative and solution-oriented working style. The ideal candidate for the role will be a self-starter and has a high degree of self-discipline to meet business objectives and requirements.
Description of Function:
Install, configure, administer, manage, and document MySQL, PostgreSQL, NoSQL (MongoDB) in a Master with Replicas configuration across several nodes already procured by CCTE for high availability and high-performance scenariosIndependently analyze, solve, and correct issues in real time, providing end-to-end problem resolutionAdvise Division management officials regarding integration of IT programs with other programs of equivalent scope and complexity. Lead engineering and architecture activities related to database performance monitoring & optimizationDevelop new theories, concepts principles and work methods to significantly improve relational and non-relational data stores for designing, configuring, implementing, and documenting relational and non-relational data stores consisting of main-replica systems. Manage database assets including maintenance of inventory and related documentationTask Responsibilities:
Provide expert level Database Administrator services for production, stage, and development databases across all platforms. Works closely with senior developers and data modelers to perform physical database design for critical business applications/databases with the largest numbers of interfaces and users and complex query tuning and schema.Use expert communication and collaboration skills to advise leadership regarding integration of IT programs with other programs of equivalent scope and complexity; lead engineering and architecture activities; provide domain and technical expertise, provide technical mentorship and cross-training to peers and team membersWork involves analyzing the user experience of a variety of Agency IT programs and recommending design changes that can enhance the user experienceAdvanced knowledge of database security, backup and recovery, and performance monitoring standardsQualifications
:
Required Qualifications:
Experience working in Linux environmentsStrong command-line experience including AWS CLI, PowerShell, and Unix shell scripting skillsExperience with Administering SQL (e.g., PostgreSQL, MySQL, etc.) and NoSQL (e.g., MongoDB) technologiesAbility to perform complex command-line scripts and perform SQL queriesExperience with AWS RDS AdministrationAbility to thrive in an environment without a database management serviceAdvanced knowledge of database security, backup and recovery, and performance monitoring standardsPreferred Qualifications:
Experience with MongoDB OpsManager is highly preferred