Sql Database Administrator

Frodoe LLC; VIP Area; On-site; INR 900,000 - 1,500,000; Full time

Job summary

An established art supply retailer is seeking a Mid-Senior level SQL DBA to oversee all databases in production and test environments. The role involves ensuring optimal performance, managing cloud databases, and implementing best practices for database administration. Candidates should possess strong knowledge in SQL Server and TSQL, with additional experience in Azure SQL and AWS Redshift preferred. Flexible work hours available.

Qualifications

• Mid-Senior level experience in database administration.
• Expertise in SQL Server 2008 to 2019.
• Experience with cloud databases, including Azure SQL and AWS Redshift.
• Identify slow-running queries and tune performance.
• Identify hardware bottlenecks affecting SQL Server performance.
• Address SSIS performance issues.
• Provide around-the-clock DBA support with the team.
• Willing to learn new technologies/tools for monitoring.
• Manage security on SQL Server databases.
• Database design/architecture knowledge and experience.
• Experience with Azure SQL DB & CosmosDB.
• SQL Replication between local SQL Servers and Azure.
• Knowledge of AWS Redshift security/performance.
• SSRS knowledge is a plus.
• PostgreSQL knowledge is a big plus.

Responsibilities

• Oversee all databases and ensure optimum performance.
• Predict future performance and maintain SQL Server databases.
• Manage cloud databases and automate administrative tasks.
• Ensure DR and HA policies are in place and followed.
• Manage server patching and maintenance communications.
• Handle cloud DBs including Azure SQL and AWS Redshift.
• Create scripts to automate DBA tasks.

Skills

Strong communication skills

Relational data management knowledge

TSQL expertise

Query performance tuning

Hardware bottleneck identification

SSIS package performance improvement

Security management on SQL Server

Database design knowledge

Azure SQL and CosmosDB experience

SQL Replication knowledge

AWS Redshift knowledge

Postgres knowledge

Tools

Azure SQL

CosmosDB

SSIS

SSRS

AWS Redshift

Job description

SQL DBA role oversees all the databases and database servers in production and test environments to make sure they’re constantly running on optimum performance. This role would also act as a gate keeper to our production environments. In addition to this, this role takes ownership of all dba related tasks.

Key Outcomes

• Oversee monitoring activities on the website database and other DBs and establish benchmarking for performance.
• Predict future performance based on new projects and upcoming events using the performance data collected.
• Maintain and monitor SQL Server Databases while maximizing availability of critical business data.
• Ensure proper DR and HA policies are in place and they’re actually followed.
• Oversee required actions to make sure all servers are patched, and the latest service pack has been applied to all the servers while maintaining an effective communication on Server Maintenance and build activities and issues.
• Manage cloud databases including Azure SQL and AWS Redshift.
• Create scripts to automate administrative tasks.

Skills or Abilities

• Strong communication skills. And willing to work in a team-oriented structure.
• Strong knowledge in relational data management, SQL Server 2008 thru 2019.
• Strong experience and knowledge over TSQL and TSQL based objects.
• Ability to identify slow running queries and performance tune those queries.
• Identify server’s hardware bottlenecks that could affect SQL Server’s performance.
• Identify shortcomings in SSIS packages performance and address those issues.
• Work with the rest of DBA team to provide around the clock support.
• Willing to learn new technologies and new tools to better monitor/manage the environments.
• Manage security on SQL Server database servers.
• Database design and architecture knowledge and experience.
• Good knowledge and experience over Azure SQL DB & CosmosDB.
• SQL Replication between local SQL Servers and Azure.
• Have some knowledge over AWS Redshift and its security and performance management.
• SSRS knowledge is a plus.
• Postgres Knowledge is a big plus.

Work hours: 4:30 PM IST to 12:30 AM IST

Salary: Will be commensurate with experience and will be on-par with the best in the industry.

About Client: Our Client is America’s oldest and largest art supply retailer, was recently voted America’s top choice for two awards—Best Online Shops and Best Customer Service in the Arts and Crafts category—for the fourth consecutive year. Since 1911, we have come to be known as the leading art supply company providing artists, educators, students, and our associates with the tools, assistance, and training needed to grow, innovate, and reach their creative potential.

If you are interested, please send your resume to [e-mail]

Seniority level

Mid-Senior level

Employment type

Full-time

Job function

Information Technology

Industries

IT Services and IT Consulting

Location

Greater Hyderabad Area