Job Description
- Manages the day-to-day operations of the database servers by monitoring system performance, configuration, maintenance and repair. Applies revisions to the software versions. Works with vendors to assist support activities.
- Expert in handling Microsoft SQL databases of multiple versions from 2008 till 2017, with topologies including Failover Cluster and Always On availability groups
- Experience in performance optimization of large SQL server clusters with several instances & DBs
- Experience in managing, updating and performance optimization of Oracle Exadata
- Performs data modeling and database design
- Evaluates and make recommendations on new database methodologies or implementation strategies.
- Handles reporting and Power BI servers to generates reports and to create dashboards as required
- Maintains security and integrity controls of the database, and database software tools. Experience in using solutions like Imperva or Guardium
- Responds to the automated alerts on the health of systems, and experiences in analyzing DB monitoring tools like Dynatrace
- Experience in backup and restore of databases at various levels (instance, DB, tables, row, etc.)
- Experience in troubleshooting the integration and access of the applications built on SharePoint, .NET, Oracle forms, etc.
- Develops new system and application implementation plans, custom scripts and testing procedures to ensure operational reliability, and automation of tasks.
- Performs troubleshooting as required. As such, leads problem-solving efforts often involving outside vendors and other support personnel and/or organizations.
- Ensures that records of system downtime and inventory are properly maintained. Ensures all work is carried out and documented in accordance with required standards, methods and procedures.