The Job logo

What

Where

SQL DBA

ApplyJoin for More Updates

You must Sign In before continuing to the company website to apply.

Smart SummaryPowered by Roshi
As an SQL DBA at Rackspace Technology, you will be responsible for database engineering and administration activities, including design, planning, monitoring, automation, and troubleshooting. The role involves formulating policies, capacity planning, patch management, automation, mentoring, and performance analysis. You will also be involved in disaster recovery planning, cloud deployments, and working with SQL Server in AWS and Azure platforms.

Job Description

Skills: SQL DBA

Location: India Remote

(Looking for Immediate joiner only)

Experience - 4+ yrs. of relevant exp.

The SQL 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

 

Key Responsibilities List

·       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.

 

Knowledge List

·       Proficient Skills in SQL Server Architecture, Installation and Configuration, Performance Tuning, High Availability and Disaster Recovery (HADR), Monitoring and Troubleshooting

·       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.

 

Desired

·       Experience working with Postgresql /MySQL/AWS RDS

·       Database Specialty Certifications in AWS id preferred.

·       Experience working in AWS cloud environments.


 

Set alert for similar jobsSQL DBA role in Bengaluru, India or Gurgaon, India
Rackspace Technology Logo

Company

Rackspace Technology

Job Posted

a year ago

Job Type

Full-time

WorkMode

Remote

Experience Level

3-7 Years

Category

IT Services and IT Consulting

Locations

Bengaluru, Karnataka, India

Gurgaon, Haryana, India

Qualification

Bachelor

Applicants

12 applicants

Related Jobs

Tata Consultancy Services Logo

Postgres SQL DBAPostgres SQL DBA

Tata Consultancy Services

Bengaluru, Karnataka, India

Posted: a year ago

TCS is a global leader in technology and offers exciting opportunities for young techies. We are looking for a Database Administrator with 3-7 years of experience. The candidate must have knowledge of migration from MySQL 5.x to MySQL 8.x and strong analytical abilities to resolve post-migration issues. The candidate should also be able to guide the team in identifying the root cause of issues. This is a great opportunity to grow with TCS.

Hewlett Packard Enterprise Logo

Oracle DBA L3

Hewlett Packard Enterprise

Gurgaon, Haryana, India

Posted: 3 months ago

Job description  What you’ll do: ▪ Schema objects management ▪ Database objects re-organizations as required to manage the growth.  ▪ Data movement such as import and export of data.  ▪ Administration of user accounts & Administration of the concurrent managers.  ▪ Routine system administration e.g., user access and security, profile options, menu management, data auditing, logs monitoring, password management. Patching, testing and cloning.  ▪ Data growth Monitoring and action points including purging at regular interval.  ▪ Database Server Resources Monitoring and action points.  ▪ I/Os monitoring and management at file system level and disc level to optimize resources.  ▪ Identifying the sudden spikes. Analysis of abnormal observation and action points to resolve them  ▪ Monitoring inconsistence behaviour of database processes, scheduled jobs and take actions  ▪ Table space management. Next Extent size management  ▪ Incident’s logging and monitoring  ▪ Management, application and verification of Oracle Patches.  ▪ Conduct monthly and quarterly account reviews.  ▪ Assistance with feasibility and proof of concept analysis and design for Customer planned IT projects that involve supported Oracle programs.  ▪ Oracle program release planning  ▪ Research information on problems/ questions posed by Customer production and development DBs.  ▪ Evaluation of current backup, recovery and data replication procedures and work towards improvement of those procedures.  ▪ Creation of new database instances and their support.  ▪ Upgradation of database version from existing to latest recommended version in coordination with Customer domain owner.  ▪ Database performance analysis and performance tuning.  ▪ Logging, follow up, escalation of Oracle TARs and implementation of solution.  ▪ Execution of queries/reports in the production database  ▪ Schema Password Change Management  ▪ Monitoring of applications, regular, scheduled and ad-hoc jobs as per requirement.  ▪ Temporary database creation and management  ▪ Problem Resolution and Root Cause Analysis  ▪ Co-coordinating with other teams viz. Customer Application Team, Network Team, Storage Team, and Server Team, Helpdesk etc. to close the issue and provide countermeasures  ▪ Preparing, presenting and executing action points at regular interval to control the data growth.  ▪ Server Resources Monitoring and apprise the action points to Customer basis resource utilization trend DBA Team will be having the ownership of schema passwords of production databases.  ▪ Change schema passwords as per password policy  ▪ Keeping the service operating in the event of a fault.  ▪ Running periodic diagnostics on the availability of systems and services.  ▪ Monitoring, measuring and presenting IT service availability to Customer.  ▪ Interaction with Application Team  ▪ First Level Application Support for all applications deployed in Customer will be through applications team. DBA team will be reported any help required on database tuning or query optimization required.  ▪ DBA Team will run the queries/ programs on the production databases as per the request of application team, monitor the same and provide the application team with the output.  ▪ All the process documents created, and scripts deployed during the contract period will be property of Customer.  ▪ Whenever any major or medium release is done, DBA team will monitor and track the effects of the release / deployment.  ▪ Capturing the inefficiency of any database queries requested through the programs and coordinate with respective application team to resolve the issue.  ▪ Knowledge of ASM, disk management, ASM rebalancing  ▪ Oracle Data Guard, Oracle Active Data Guard  ▪ SQL query tuning/profiling Oracle Apps (EBS) Administration (Preferred)  ▪ Managing concurrent programs and reports  ▪ Managing conflict domains  ▪ Managing users  ▪ Managing resource consumer groups and their hierarchies Configuration of multiple nodes Optimization of database performance and tuning.  ▪ Monitoring of regular and scheduled jobs on ERP.  ▪ Monitoring of regular and scheduled jobs on ERP and ensure improvement in coordination with Customer domain owner and respective application team  ▪ Apps cloning and patching, troubleshooting  ▪ Knowledge of ERP forms and RDF release in production environment   What you need to bring: B.E. / B. Tech/BCA (On-Site), Relevant Certification (Preference). 8+ Years relevant experience, ITIL Certified, OEM Certified on Minimum One Technology Technology: Oracle, Data Guard, RAC, RMAN, OEM Certification: OCP (Oracle Certified Professional) Team Management – should be able to manage the team of 10-12 resources ✓ Customer SPOC for Oracle Database Domain ✓ Communication and Problem-Solving - Excellent communication skills and the ability to visualize algorithmic structures. ✓ Process Knowledge – Incident, Change & Problem Management skills (should be able to perform RCAs for the Severity1 & repetitive incidents)  ✓ Should have Collaborative approach, Adaptability   Technical Skills: ✓ RDBMS: Oracle 19c, 12c, 11g. ✓ Oracle Applications: Oracle Apps (EBS), Oracle Forms ✓ Operating systems: Linux, RHEL, IBM-AIX, HP-UNIX ✓ Tools & Utilities: Oracle Enterprise Manager (OEM), ITSM Tools (ServiceNow, Symphony SUMMIT), JIRA