Full Job Description
Job Description Summary
Knowledge, Skills, and Abilities Requirements: List unique knowledge, skills, or problem-solving requirements.
Database Performance and TuningHardware analysis (Disk I/O, Network I/O, Processors, Memory)Database Configuration ManagementDatabase Capacity Planning and MonitoringTroubleshootingWait State AnalysisDatabase Backups/Restores TechnologiesImplementing New Database servers in a Virtual EnvironmentDatabase Design Skills including Normalization and Data Warehouse designStrong TSQL skillsStrong analytical skillsStructured Troubleshooting SkillsSQL Query Performance Tuning experienceLog Shipping, Mirroring and Always-on technologiesReplicationExperience with SentryOne and other 3rd party Monitoring ToolsExperience in the healthcare industry, a plus
Job Description
Position 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:
1.
Owning, tracking and resolving database related incidents and requests
2.
Ensuring the Performance and Stability of the RDBMS platforms
3.
Providing, reviewing and resolving service related alerts/reports for maintenance, capacity, performance, ETL status
4.
Diagnose and resolve database performance issues.
5.
Proactively monitor the system
6.
Deploy database change scripts in multiple environments
7.
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:
6-8 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 SentryOne and other 3rd party Monitoring Tools
Experience in the healthcare industry, a plus
Toolset:
Microsoft SQL Server 2014 thru 2019
Microsoft SQL Server 2017 Reporting Services (SSRS)
Knowledge and experience with Transact SQL (stored procedure, trigger and constraint development)
Azure Database
MS-Windows
Physical/Mental Requirements:
Ability to communicate clearly both verbally and in writing.
Ability to analyze complex application and business operational issues.
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
Primary Work Location
IND Chandigarh – DLF IT Park
Additional Locations
Work Shift
Job Description br{display:none;}.css-58vpdc ul > li{margin-left:0;}.css-58vpdc li{padding:0;}]]> Need an Accountant on having minimum 3-4 years of experience in Taxation, Accountancy,...
Apply For This JobJob Description Develops strong and innovative digital marketing strategies, using SEO, PPC, and other techniques to drive traffic to company...
Apply For This JobFull Job Description Date: 26-Feb-2022 Location: Chennai Company: Mahindra & Mahindra Limited Responsibilities & Key Deliverables The tasks correspond to...
Apply For This JobFull Job Description Date Posted: 2023-02-02 Country: India Location: North Gate Business Park Sy.No 2/1, and Sy.No 2/2, KIAL Road,...
Apply For This Jobbr{display:none;}.css-58vpdc ul > li{margin-left:0;}.css-58vpdc li{padding:0;}]]> – A Senior Account Manager will be responsible for maintaining & Sustaining a long term...
Apply For This JobJob Description We offer you a freelance Content writer part time job. It is completely Work From home opportunity. If...
Apply For This Job