Title: Database Automation Engineer
Location: IN-Kerala-Kochi
Job Number: GSS003IX
Job Summary:
The Database Engineer performs operational and environment support for the SQL database, Windows Server Platforms and associated applications in a range of business portfolios. Responsibilities involve the daily troubleshooting and resolution of incidents, operational maintenance and support, application and environment change control, and proactive/preventative analysis of systems. Post-holder performs systems operations and analysis across complex hosted environments including shared and clustered environments, and provides consultation to other teams within Ernst and Young including, but not limited to, architecture, development, and project management.
br> br>
Qualifications:
Essential Functions of the Job:
· Re-creation, analysis, troubleshooting, and diagnosis of incidents relating to platforms and/or application environments.
· Execution of application and/or platform changes, releases, and service requests in supported environments.
· Execution of application environment tasks as required for incident resolution
· Determination of root cause of platform specific incidents
· Liaise with appropriate teams for the development of corrective actions or viable workarounds to resolve major incidents.
· Responding to automated alerts on the health of systems.
· Executing scheduled or unscheduled tasks relating to operational maintenance and monitoring of application environments.
· Performing audits and analysis of application environments for the purpose of ensuring proper configuration management and consistency.
· Identifying dependencies and pre-requisites for the solution and validation of non-functional attributes of the application environment design.
· Integrating new infrastructure services based on designs, and participating in automation, consolidation, and centralization projects.
· Adhere to E&Y, TGOF and ITIL guidelines for Incident, Problem, and Change Management
· Ensures all work is carried out and documented in accordance with required standards, methods and procedures.
Analytical/Decision Making Responsibilities:
· Selects appropriately from applicable standards, methods, tools and applications and use accordingly.
· Ability to work well within a multi-disciplinary team structure, but also independently
· Ability to work with 3rd party vendors (i.e. Microsoft) for escalation of issues
· Ability to manage multiple tasks with shifting priorities
· Ability to build and maintain strong working relationships with other DBAs and application teams
· Demonstrates analytical and systematic approach to problem solving.
· Communicates fluently orally and in writing and can present complex technical information to both technical and non-technical audiences.
· Is able to plan, schedule and monitor work activities in order to meet time and quality targets.
· Is able to absorb rapidly new technical information, business acumen, and apply it effectively.
· Good appreciation of wider field of information systems, its use in relevant employment areas and how it relates to the business activities of the employer or client.
Knowledge and Skills Requirements:
Required technical experience & qualifications
· Deep knowledge of SQL Server High Availability Options:
o AlwaysOn Availability Groups
o AlwaysOn FCIs
o Geo-WSFCs
o Geo-FCIs
o Database Mirroring
o Log Shipping
o Storage-Level Replication
· Deep knowledge of SQL Server Scalability Options:
o AlwaysOn Availability Readable Secondary (Read-Only Routing)
o Replication – Merge, Peer-to-Peer and Transactional
o Database Snapshots
· Deep knowledge of Advanced SQL Server Diagnostic Tools:
o Extended Events
o DMOs (DMVs/DMFs)
o PAL 1.x
o Leverage RAS remediation reports
o XPerf/ETW
· Deep knowledge of Windows Server 2012 :
o Configuration Best Practices
o Perfmon
o DNS Configuration/NIC configuration
o WSFC (Windows Server Failover Clustering)
§ Deployment
§ Configuration
§ Backup and Recovery
§ Troubleshooting
o PowerShell
o Leverage RAS remediation reports
· Multifaceted understanding Managing SQL Server Internal/External clouds:
o Both theoretical and hands on knowledge on optimization SQL Server on-premises VMs (VMware/Hyper-V)
o Both theoretical and hands on knowledge on optimization SQL Server on a cloud platform (IaaS/PaaS)
o Deep knowledge on troubleshooting SQL Server running on a virtual platform
o Hand-on experience provisioning and configuring high-availability in a Cloud Platform
o Understanding of Active Directory Federation in Azure
· Strong understanding of PowerShell
o Automate common tasks via PowerShell
o Perform multi-instance operations via PowerShell
o Provision SQL Server via PowerShell
o Remoting/WSMAN
· Strong understanding of SAN Storage (EMC VNX/VMAX and 3PAR)
o Through understanding RAID configuration
o Strong understanding how to optimize storage for SQL Server
o How to troubleshoot and identify and storage related performance issues
· Demonstrable knowledge of SQL Server Analysis Services (SSAS)
o How to optimize SSAS
o Profile SSAS queries
o Scale-out SSAS
· Demonstrable knowledge of SQL Server Integration Services (SSIS)
o How to optimize SSIS
o How to configure and read SSIS Logs
o How to perform mass deployments of SSIS
· Demonstrable intermediated to advanced knowledge of Database Level Encryption
o SQL Server Transparent Database Encryption (TDE)
o Vormetric
o Column Level Encryption
· Strong working knowledge of SQL best practices (e.g. schema management, index optimization, etc.)
· Experience in support of business intelligence solutions/applications or experience in managing large data warehouse environments
· Understanding of n-Tier application environments in complex or enterprise level environments
· Strong working knowledge on 3rd Party Monitoring and Analytics Tools
o Microsoft System Center Operations Manager (SCOM)
o Splunk for Enterprise
o AppDynamics
§ End User Experience
§ Dashboard creation/management
· Strong working knowledge on 3rd Party Backup and Recovery Tools
o Symantec NetBackup 7.x
o EMC Recovery Point
· Deep understanding on provisioning/monitoring/managing SQL Server on Virtual Machines (Hyper-V and VMWare)
· Strong communication skills is must
· Strong understanding of ITIL principles desirable
Desired technical experience & qualifications
· Ability to develop and communicate technical concepts.
· Strong knowledge of computers, network, and software roadmaps.
· Demonstrated problem investigation and resolution skills.
· Understanding of Project management concepts.
· Experience with data warehousing and operational data stores.
Supervision Responsibilities:
· At least 5 years in lead role managing both technical/non-technical resources
· At least 3 years in Operations lead role, providing guidance for of day-to-day operational activities
Other Requirements:
· Participate in a fixed shift pattern/on-call rotation/weekends
· Flexibility in scheduling with a willingness to work extra non-standard hours on occasion
· Ability to work well within a multi-disciplinary, multi-cultural team structure, but also independently
· Strong interpersonal and verbal and written communication skills
· The ability to drive and manage application outages
Education:
· Degree in Computer Science or related discipline or equivalent work experience
<p style="MARGIN: 0cm 0cm 0pt 36pt; LINE-HEI