Position : Sr Database Administrator - Pacific hours
Location : San Diego, CA
Duration : 6+ Months
Total Hours/week : 40.00
1st Shift
Client : Medical Devices Company
Job Category : Engineering/Technical
Level of Experience : Senior Level
Employment Type : Contract on W2 (Need US Citizens or GC Holders or GC EAD or OPT or EAD or CPT)
Temp to perm Possibility
Job Description
I. Department Overview
- The STS department is responsible for developing and maintaining commercial grade software products, that are complying and supportive of the overall architectural and product strategy.
- Utilizing best practices within the industry, as well as the currently defined technology stack, this department is responsible for delivering high quality, highly stable, and robust applications that perform to present and future expectations.
II. Purpose
- The production database administrator is primary responsible for protecting corporate data assets and ensuring we hit defined SLAs and delivery deadlines via the execution and monitoring of backups, troubleshooting service outages, resolving database performance issues and ensuring the security of the system. This role will work closely with the development and QA teams to ensure that we can release and maintain our products.
III. Specific Duties, Activities, And Responsibilities
- Owning, tracking and resolving database related incidents and requests
- Ensuring the Performance and Stability of the RDBMS platforms
- Providing, reviewing and resolving service-related alerts/reports for maintenance, capacity, performance, ETL status
- Diagnose and resolve database performance issues.
- Proactively monitor the system
- Deploy database change scripts in multiple environments
- Help evaluate new technologies for inclusion in the environment
IV. Position Requirements
Education or Equivalent
- BS in Computer Science or Information Systems or Equivalent Work Experience
Experience Or Equivalent
- 8-10+ years’ experience working on relational database platform with emphasis on VLDBs.
- On-call deployment and troubleshooting experience
- Experience with database design principles, including normalization and aggregation, for both on-line and data warehouse schemas to support the needs of application developers.
Knowledge, Skills, and Abilities Requirements: List unique knowledge, skills, or problem-solving requirements.
- Database Performance and Tuning
- Hardware analysis (Disk I/O, Network I/O, Processors, Memory)
- Database Configuration Management
- Database Capacity Planning and Monitoring
- Troubleshooting
- Wait State Analysis
- Database Backups/Restores Technologies
- Implementing New Database servers in a Virtual Environment
- Database Design Skills including Normalization and Data Warehouse design
- Strong TSQL skills
- Strong analytical skills
- Structured Troubleshooting Skills
- SQL Query Performance Tuning experience
- Log Shipping, Mirroring and Always-on technologies
- Replication
- Experience with Foglight and other 3rd party Monitoring Tools
- Experience in the healthcare industry, a plus
- Analyze, solve, and correct database issues in real time.
- Provide suggestions for solutions.
- Refine and automate regular processes.
- Track issues and document changes.
- Assist developers with query tuning and schema refinement.
- Minimize database downtime.
- Implement high-speed transaction recovery techniques
- Provide 24x7 on call rotation support for critical production systems.
- Perform scheduled maintenance and support release deployment activities after hours
Toolset
- Microsoft SQL Server 2014 thru 2022
- Microsoft SQL Server 2017 Reporting Services (SSRS)
- Knowledge and experience with Transact SQL (stored procedure, trigger and constraint development)
- Azure Database
- MS-Windows
- Snowflake
Physical/Mental Requirements
- Ability to communicate clearly both verbally and in writing.
- Ability to analyze complex application and business operational issues.
- Critical thinking and problem-solving skills.
- Ability to work well in a team.
- Good time-management skills.
Any Additional Important Information
The Production DBA will be additionally responsible for the following tasks:
- Ensuring appropriate and detailed documentation
- Supporting application developers
- Estimation and timely completion of tasks
- Following quality assurance processes
