Job Description Summary:
The Database Administrator Perform database engineering and administration activities including design planning configuration monitoring automation self- serviceability alerting and space management database backup and recovery. Plan computerized databases including base definition structure documentation long- range requirements operational guidelines and protection with a capacity to lead and advise on migration and modernization discover and execute workload migrations to Cloud (AWS/Azure/GCP).
Job Description:
* Create maintain and use Standard Operating Procedures (SOP’s) for migration execution and ensure long term technical viability and optimization of production deployments and administration.. * Engage Consult and Deliver based on interactive customer communications in streamlining project deliverables and scope of work.. * Capacity Planning: Forecast future database growth based on usage trends and plan for hardware and storage requirements accordingly to ensure scalability and optimal performance.. * Plan Create Manage and Deploy Effective High Availability and Disaster Recovery strategy/Runbooks.. * Patch Management and Upgrades: Plan and execute Database software upgrades patches and service packs.. * Troubleshooting and Issue Resolution: Investigate and resolve complex database-related issues including data corruption performance problems and connectivity challenges.. * Automation and Scripting: Contribute to automation scripts and tools to streamline repetitive tasks improve efficiency and reduce the risk of human errors.. * Monitoring and Alerting: Set up monitoring and alerting systems to proactively identify and address potential database issues before they become critical.. * Performance Analysis and Reporting: Generate performance reports and analysis for stakeholders and management to provide insights into the database environment's health and performance.. * Documentation: Maintain up-to-date documentation of database configurations procedures and troubleshooting steps. * Ticket Handling: Work to resolve Incident Changes and Service request under the agreed client SLA.. * Problem Management: Responsible in resolving problem tickets by creating detailed RCA reports.. * Vendor and Third-Party Tool Management: Evaluate and manage third-party tools and solutions that assist in database management monitoring and performance tuning.. * Participate in 24X7 production support for Database Operations.. * Hand’s on with using cloud tech tools such as AWS DMS SMS App Migration Service Migration Hub Azure Migrate Data Migration Service SQL Server DMA Azure ASR AWS DRS. * Migration from SQL server to/from Other RDBMS platform for PaaS models like AWS Aurora AWS RDS Azure Database Azure MI GCP Cloud SQL.. * Understanding Cloud basics and perform duties like security management storage management Backup Vaults Key vaults Server/DB Monitoring. Cost Optimization: Compute and workload analysis License enhancements and features.