Skills: MSSQL DBA with AWS/Azure
Location: India Remote
Experience - 10+ yrs. of relevant exp.
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).
Key Responsibilities List
· Create, maintain, and use Standard Operating Procedures (SOP’s) for migration execution and ensure long term technical viability and optimization of production deployments
· Plan, Create, Manage and Deploy Effective High Availability and Disaster Recovery strategy.
· Worked on performance comparison and optimization
· 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 Migration Assistant
· Migration from SQL server to/from Other RDBMS platform for PaaS models like AWS Aurora, AWS RDS, Azure SQL, GCP Cloud SQL.
· Formulate and monitor policies, procedures and standards relating to database management.
· Provide design standards and guidance for projects and technical roadmaps.
· Capacity Planning: Forecast future database growth based on usage trends and plan for hardware and storage requirements accordingly to ensure scalability and optimal performance.
· Patch Management and Upgrades: Plan and execute SQL Server software upgrades, patches, and service packs. Stay up to date with the latest SQL Server releases and features.
· Troubleshooting and Issue Resolution: Investigate and resolve complex database-related issues, including data corruption, performance problems, and connectivity challenges.
· Automation and Scripting: Develop 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.
· Compliance and Best Practices: Ensure that databases comply with industry standards and internal policies. Follow best practices for database management, security, and performance optimization.
· Mentoring and Training: Provide guidance and support to Level 1 and Level 2 DBAs, sharing knowledge and expertise to foster their professional growth.
· 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.
· Vendor and Third-Party Tool Management: Evaluate and manage third-party tools and solutions that assist in database management, monitoring, and performance tuning. Resolve locking conflicts/blocking and resource utilization. Build tools for customers and internal teams by creating scripts or using software to automate administration tasks and DBA processes.
· Consult with customers on SQL Server including best practices and SQL Server Disaster Recovery setups.
· 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. Carry out disaster recovery planning and execution including, log shipping, mirroring, replication, and AlwaysOn.
· Works with the product organization to assist in the roll out of new products.
· Participate in 24X7 production support for SQL Server infrastructure.
· Executes large sized, complex database projects. Ensures projects are properly documented.
· Proficient Skills in SQL Server Architecture, Installation and Configuration, Performance Tuning, High Availability and Disaster Recovery (HADR), Monitoring and Troubleshooting, Migration
· Database Migrations and Upgrades: Experience in planning and executing database migrations and upgrades, including version compatibility, testing, and minimizing downtime.
· SQL Server in the Cloud: Knowledge of deploying and managing SQL Server in cloud platforms such as Azure SQL Database and Amazon RDS.
· SQL Server Best Practices: Familiarity with industry best practices for SQL Server administration, including configuration settings, maintenance tasks, and disaster recovery strategies.
· Ability to communicate technical info and ideas so others will understand.
· Ability to apply varying leadership skills and traits that create solutions and results to unexpected situations.
· Experience working with Postgresql /MySQL/AWS RDS
· Database Specialty Certifications in AWS/Azure.
· Experience working in AWS/Azure cloud environments.
o Experience working in Automation with Python/AWS CLI/PowerShell/Shell
o Working on Infrastructure as a code with Cloud Formation, Terrafrom , Github
About Rackspace Technology
We are the multicloud solutions experts. We combine our expertise with the world’s leading technologies — across applications, data and security — to deliver end-to-end solutions. We have a proven record of advising customers based on their business challenges, designing solutions that scale, building and managing those solutions, and optimizing returns into the future. Named a best place to work, year after year according to Fortune, Forbes and Glassdoor, we attract and develop world-class talent. Join us on our mission to embrace technology, empower customers and deliver the future.
More on Rackspace Technology
Though we’re all different, Rackers thrive through our connection to a central goal: to be a valued member of a winning team on an inspiring mission. We bring our whole selves to work every day. And we embrace the notion that unique perspectives fuel innovation and enable us to best serve our customers and communities around the globe. We welcome you to apply today and want you to know that we are committed to offering equal employment opportunity without regard to age, color, disability, gender reassignment or identity or expression, genetic information, marital or civil partner status, pregnancy or maternity status, military or veteran status, nationality, ethnic or national origin, race, religion or belief, sexual orientation, or any legally protected characteristic. If you have a disability or special need that requires accommodation, please let us know.