Senior Discovery Database Administrator, Top Secret Clearance Required
CGS Federal (Contact Government Services)
CloudMS SQL ServerSQL
Senior Database Administrator
IEHP
full-time
Posted on:
Location Type: Hybrid
Location: Rancho Cucamonga • California • 🇺🇸 United States
Visit company websiteSalary
💰 $118,602 - $157,144 per year
Job Level
Senior
Tech Stack
LinuxMongoDBMS SQL ServerSQL
About the role
- Create, configure, monitor, and maintain databases in a large, highly available, distributed, enterprise production database systems.
- Recommend solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.
- Maintain database performance; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products.
- Demonstrate extensive knowledge of all aspects of Microsoft SQL Server and MongoDB including administration, replication, backup/restore procedures, and related components such as Reporting Services, Analysis Services, and Integration Services.
- Work outside of normal business hours as required for completing projects, working on deployments, and resolving system outages.
- Work with DBAs to determine where the databases will reside in multi-tier distributed/shared applications, comparing hardware/infrastructure alternatives in conjunction with cost, use, growth, supportability.
- Define database authorization rules, perform security audit, and perform platform assessment regarding proper support for the selected databases.
- Read and implement entity-relationship diagrams.
- Develop alerts, reports, and automated processes for failed jobs.
- Design and develop complex database design from high level business requirements.
- Must be able to provide database design options, alternatives and recommendations based on experience and best practices for database design.
- Understand SAN based storage and related technologies, specifically as applicable and useful to MS SQL Server installations.
- Establish standards for documentation and ensure that all designs are documented.
- Establish standards for permissions and privileges to databases.
- Develops, manages, and tests back-up and recovery plans; handles seamless failover and recovery.
- Work with Systems team on planning server hardware, storage, and OS configuration upgrades.
- Monitor MS SQL performance through Solarwinds, reporting and remediating any issues within the published SLAs.
- Perform SQL server migrations - adhering to best practices.
- Participate in on-call rotation for 24/7 database support.
- Train, mentor, and guide.
Requirements
- Seven (7) years of experience performing database architecture, management, modification and support with five (5) years working with Microsoft SQL Server
- Experience in supporting large, highly available, distributed, enterprise production database systems
- Experience and knowledge in the design and implementation of new DBMS systems, programming, analysis and design, systems development or systems administration, MSSQL low-level database, query development and Stored Procedure tuning and optimization, tuning data structures, indexing and queries, managing production databases with replication, hot stand-by, clustering, and table partitioning and working in a team-oriented, collaborative environment
- Experience working in a 24/7/365 environment and taking a lead role in architecting, designing, and building complex database systems
- Experience with both Windows and Linux operating systems is preferred.
- Experience in programming, analysis and design, systems development, or systems administration preferably in a healthcare setting
- Bachelor’s degree in a quantitative field from an accredited institution required
- In lieu of the required degree, a minimum of four (4) years of additional relevant work experience is required for this position. This experience is in addition to the minimum years listed in the Experience Requirements above
Benefits
- Competitive salary
- Hybrid schedule
- State of the art fitness center on-site
- Medical Insurance with Dental and Vision
- Life, short-term, and long-term disability options
- Career advancement opportunities and professional development
- Wellness programs that promote a healthy work-life balance
- Flexible Spending Account – Health Care/Childcare
- CalPERS retirement 457(b) option with a contribution match
- Paid life insurance for employees
- Pet care insurance
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
database architecturedatabase managementMicrosoft SQL ServerMongoDBquery developmentStored Procedure tuningdatabase replicationclusteringtable partitioningbackup and recovery
Soft skills
team-orientedcollaborativementoringguidingproblem-solvingcommunicationleadership
Similar jobs on JobTailor
Senior Discovery Database Administrator, DBA
CGS Federal (Contact Government Services)
CloudMS SQL ServerSQL
Senior Database Administrator
CGS Federal (Contact Government Services)
ASP.NETAWSAzureCloudMS SQL Server.NETPostgresSDLCSQLVMware
Senior Discovery Database Administrator
CGS Federal (Contact Government Services)
CloudMS SQL ServerSQL