Project Role :
Operations Engineer
Project Role Description :
Support the operations and/or manage delivery for production systems and services based on operational requirements and service agreement.
Must have skills :
Microsoft SQL Server Administration
Good to have skills :
NA
Minimum 3 Year(s) Of Experience Is Required
Educational Qualification :
15 years full time educationSummary: As an Operations Engineer, you will support the operations and manage delivery for production systems and services based on operational requirements and service agreements. A typical day involves monitoring system performance, troubleshooting issues, and collaborating with team members to ensure seamless service delivery. You will engage in proactive maintenance and contribute to optimizing operational processes, ensuring that all systems run efficiently and effectively to meet organizational goals. Key Responsibilities Technical Experience Professional Attributes Educational Qualification: "
- Plan and implement medium to high risk changes on high profile production MS SQL
- Analyze and assess the impact and risk of low to medium risk changes on high profile production databases.
- Resolve difficult/complex incidents affecting the operation/availability of high profile production databases.
- Create and review technical system recovery plans
- Help to idenitify and plan RCA implementation.
- Make pro-active suggestions for service improvements.
- Knowledge on cross DB platforms like Sybase, MySQL.
- Prepare Runbooks as needed and review all SOPs.
- Automate the manual tasks and recurring incidents.
- Adhere to SLAs." "
- 4-6 Years of database administration on distributed platforms.
- Setup/Configuration/Support/ Upgrade of SQL server 2012,2014,2016,2017,2019 (Standalone, SQL failover cluster, always -on etc.) and MS Azure.
- Must have extensive experience to support large size, high volume, and ctirical sql server environments.
- Proficient in Database installation, setup, upgrade, and space management procedures.
- implementing and configuring DR soultions like always On, Replication, log shippping, mirroring.
- Experience installing, Maintaining SQL server in a windows environment.
- Ability to detect and troubleshoot sql server CPU, memory, I/O, disk space and other resources contention related issues.
- Understanding of SQL server encryption options like TDE.
- Good experience with backups, restores and recovery models.
- Good experience of high availability(HA) and Disaster recovery(DR) options for sql server.
- Critical thinker and problem solving skills.
- Good time-management skills, Great interpersonal and communications skills
- Good experience with powershell scripting." "
- Good verbal and written communication skills to connect with customers at varying levels of the organization.
- Ability to operate independently and make decisions with little direct supervision
- Flexible to work in 24/7 shift
- Must be a team player
- Must be capable to upscale and take initiative to deliver the task independently.
- Must be open to learn and and work on new technologies." "1. Bachelor’s degree 2. ITIL V3/V4 Foundation certified 3. Peferred to have MCSA certification. 4. Prefered to have knowledge/certification on any Cloud Technologies." Additional Information: - The candidate should have minimum 3 years of experience in Microsoft SQL Server Administration. - This position is based at our Pune office. - A 15 years full time education is required., 15 years full time education
