Description
Kforce has a client in Commerce, CA that is seeking a Senior Database Administrator that is responsible for developing and implementing ongoing assessment of database performance and the identification of problem areas. The Senior Database Administrator develops a security scheme for the database environment, as well as assisting in disaster recovery if necessary. Responsibilities Ensuring that AltaMed databases are performing optimally through performance tuning, including: storage balancing, re-indexing, aggregation, partitioning, migration and maintenance plans Configures and validates database backup routines on a regular basis Manages database-related release management activities for development, staging and production systems Implement/maintain distributed availability groups and replication involving cloud sources Works closely with developers to develop and optimize the performance of stored procedures and T-SQL Designs both the physical and the logical database administration functions Develops scripts and tools used to conduct ongoing database monitoring Establish policies and procedures pertaining to management, security, maintenance, and use of the databases Develops and maintains a security scheme for the database environment, as well as assisting in disaster recovery Assesses hardware infrastructure and its ability to support optimal database performance including but not limited to memory, disk, and disk subsystems Monitors machine-to-machine communication between SQL databases and respond to alerts or job failure messages Work with vendors in evaluating and implementing new technologies Provide highly responsive engagement for 24 x 7 support on premise and while in rotating on-call schedules Configure SQL Sentry monitoring tool to automate monitoring and notifications Upgrade out of compliance SQL server to a Microsoft supported version
Requirements
Bachelor's degree in Computer Systems Design and/or Computer Science or related field required A minimum of 5 years of hands-on DBA experience with Microsoft SQL server, database design (modeling, schema design, normal form and dimensional) and developing Script, SSIS and T-SQL 5+ years of experience with query optimization, SQL maintenance plans and disaster recovery also required Must have strong hands-on experience of Always-on and AG Hands-on experience with availability groups, distributed availability groups, replication, log shipping is highly desired
The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.
We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.
Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.
This job is not eligible for bonuses, incentives or commissions.
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.