MILLENNIUMSOFT
Sr Database Administrator - Pacific hours
MILLENNIUMSOFT, San Diego, California, United States, 92189
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)
Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr
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)
Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr