Job Description
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
Manages and guides a team of database engineers to ensure their deliverables meet program requirements.
Leads the database engineer’s forum and drives resolution of issues.
Manages multiple database systems by providing subject matter expertise when needed and directing the work of others.
Influences policy and procedure development to ensure alignment with IT strategy.
Leads others in the use of analytical models and develop breakthrough insights or innovative solutions.
Capitalizes on deep understanding of (current or potential) business processes, strategic objectives, and challenges to anticipate and meet customer needs.
Establish credibility and build impactful relationships with our customers to enable them to be cloud advocates.
Capture and share industry best practices amongst the community.
Networks with key decision makers, leveraging a deep understanding of their unique perspectives and priorities to create and expand relationships.
Demonstrates expert knowledge of and monitors the customer’s industry and competitive environment to create effective customer solutions.
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.
Formulate and monitor policies, procedures and standards relating to database management.
Provide design standards and guidance for projects and technical roadmaps.
Mentoring and Training: Provide guidance and support to Level 1 and Level 2 DBAs, sharing knowledge and expertise to foster their professional growth.
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: Suggest, Develop, Analyse, provide solutions for automation initiatives 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/Accountable for 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 sales implementations vendor calls to provide advanced knowledge in the purchase of software, hardware or services that can be used to improve the performance of the database server.
Works with the product organization to assist in the roll out of new products.
Participate in 24X7 production support for Database Operations.
Executes large sized, complex database projects. Ensures projects are properly documented and delivered.
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.
Skills List
Experience working in Automation with Python/AWS CLI/PowerShell/Shell
Working on Infrastructure as a code with Cloud Formation, Terraform, GitHub
Ability to Deploy, Manage and Troubleshoot HADR config in one of the following tech buckets SQL Server (Always On, FCI, Loshipping, Replication) or Oracle(RAC, Data guard, Golden Gate) , MySQL & PostgreSQL( Master slave replication, InnoDB cluster Set)
Knowledge of deploying and managing RDBMS in cloud platforms such as Azure SQL Database or/and Amazon RDS or/and GCP Cloud SQL
Homogeneous and Heterogeneous Migrations from/to between various Tech bucket (SQL Server or/and Oracle or/and PostgreSQL or/and MySQL)
Understanding of Monitoring tools such as Datadog or/and Azure monitor or/and AWS CloudWatch alerting and performance analyzation.
Understanding and usage of ITIL based tickets tools like Service Now.
Understanding and usage of tools like Jira, Confluence etc.
