Sr Database Administrator - Pacific hours Join to apply for the Sr Database Administrator - Pacific hours role at MillenniumSoft Inc Sr Database Administrator - Pacific hours Join to apply for the Sr Database Administrator - Pacific hours role at MillenniumSoft Inc Get AI-powered advice on this job and more exclusive features. 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 Seniority level Seniority level Mid-Senior level Employment type Employment type Full-time Job function Job function Information Technology Industries Staffing and Recruiting Referrals increase your chances of interviewing at MillenniumSoft Inc by 2x Sign in to set job alerts for “Senior Database Administrator” roles. Staff Engineer - Finance Data Specialist (Remote) Senior Engineer - Finance Data Specialist Poway, CA $100,000.00-$215,000.00 2 weeks ago Senior Staff Engineer - Finance Data Specialist (Remote) We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr
MILLENNIUMSOFT