SQL Database Administrator

Found in: Appcast Linkedin IN C2 - 2 weeks ago

Hyderabad, India ADP Full time

JOB TITLE: SQL Production Database Administrator (DBA)

DEPARTMENT: SBS RUN

JOB PURPOSE: The SQL Production Database Administrator (DBA) will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, ensuring the availability and consistent performance of the RUN application. The successful candidate will be responsible for monitoring, maintaining and updating SQL Server Clusters within a 24x7 Production environment. They must also be able to diagnose database related application problems, perform root cause analysis and recommend corrective action in coordination with other Engineering DBAs and Application Developers. The candidate will also provide DBA support for other non-production environments as required.

KEY RESPONSIBILITIES:

  • Optimize production system and identify bottlenecks, ensuring high levels of data availability.
  • Liaise with Developers and Engineers and provide SQL Server database expertise when needed.

KEY DUTIES/TASKS:

  • Monitors business critical production SQL Server clusters during peak hours and respond to incidents to ensure high levels of availability.
  • Performs SQL Server 2017 cluster and standalone installation and configuration in accordance with documented standards.
  • Collects detailed SQL Servers performance metrics and makes tuning recommendations.
  • Investigates root cause for database related application errors (Blocking, SQL timeouts, deadlocks, unexpected data condition etc.) in real time, provides document explaining root cause and recommends fixes (including recommending changes to application stored procedures) to avoid future recurrences.
  • Coordinates the database portion of the disaster recovery plan and participates in the planning, testing and implementation of recovery procedures.
  • Manages SSRS data warehouse and provides guidance and assistance to reports developers working to meet business reporting requirements.
  • Monitors and optimizes schedules for SQL Server Agent based maintenance jobs (backups, statistics maintenance, index maintenance, etc.)
  • Coordinates with Senior DBA staff and Engineers to provide input for capacity planning.
  • Coordinates with Senior DBA staff to establish and document standards for database administration relevant to the RUN application.
  • Assist application developers with complex query tuning, schema refinement, and stored procedure optimization according to company conventions and best practices.
  • Writes or peer reviews DML scripts to correct data conditions and processes scripts through issue management system
  • Reviews other Database Developer’s code for accuracy, standards, good coding practices, and adherence to documentation standards
  • Ensures data security by enforcing ADP and team security standards
  • Provides SQL Server DBA support for non-production SQL Server environments
  • Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
  • Create automation for repeating database tasks
  • Provide 24x7 support for critical production systems
  • Perform scheduled maintenance and support release deployment activities after hours

Skills and Qualifications:

  • Solid understanding of relational database concepts and best practices
  • Intermediate level knowledge of SQL 2014/2017 Database Administration
  • SQL Server AlwaysOn Clusters
  • SQL Server Reporting Services (SSRS)
  • SQL Server Integration Services
  • SQL Profiler
  • Experience with scripted database maintenance
  • Experience troubleshooting stored procedure performance (executions plans, IO statistic)
  • Experience troubleshooting deadlocks
  • Experience with backups, restores and recovery models
  • Excellent knowledge of T-SQL, Stored Procedures, Functions, Triggers and Linked Servers
  • Exposure to enterprise-level database systems with distributed data architectures
  • Excellent knowledge of database monitoring, SQL Server internals and root cause analysis (Spotlight and Splunk a plus)
  • PowerShell and Unix shell scripting skills
  • Outstanding oral communication and writing skills
  • Strong analytical and business process skills
  • Strong mathematical and statistical knowledge
  • Ability to effectively prioritize and execute tasks under pressure to meet tight deadlines
  • Flexible, team player, “get-it-done” personality. Ability to multi-task and context-switch effectively between different activities and teams
  • Highly self-motivated and directed with an impeccable attention to detail
  • Experience with Azure, MongoDB, MariaDB (MySQL/NoSQL), and Redis is a plus

EDUCATION AND EXPERIENCE:

  • Bachelor’s degree in computer science or a related field
  • 6-10 years of experience supporting enterprise SQL Server 2014 (or newer) database applications with focus on Database Administration
  • Experience with cloud services (AWS, Microsoft Azure) a plus
  • MCSA SQL Server or MongoDB certifications

  • SQL Database Administrator

    Found in: Whatjobs IN C2 - 2 weeks ago

    hyderabad, India ADP Full time

    JOB TITLE: SQL Production Database Administrator (DBA)DEPARTMENT: SBS RUNJOB PURPOSE: The SQL Production Database Administrator (DBA) will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, ensuring the availability and consistent performance of the RUN application. The successful...

  • SQL Database Administrator

    Found in: Talent IN 2A C2 - 2 weeks ago

    Hyderabad, India ADP Full time

    JOB TITLE: SQL Production Database Administrator (DBA)DEPARTMENT: SBS RUNJOB PURPOSE: The SQL Production Database Administrator (DBA) will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, ensuring the availability and consistent performance of the RUN application. The successful...

  • SQL Database Administrator

    Found in: Whatjobs IN C2 - 2 weeks ago

    Hyderabad, India ADP Full time

    JOB TITLE: SQL Production Database Administrator (DBA) DEPARTMENT: SBS RUN JOB PURPOSE: The SQL Production Database Administrator (DBA) will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, ensuring the availability and consistent performance of the RUN application. The successful...

  • Database Administrator

    6 days ago

    Hyderabad, India Cubic Corporation Full time

    Business Unit: Cubic Corporation Company Details: Cubic offers an opportunity to provide innovative technology for government and commercial customers around the globe, helping to solve their future problems today. We’re the leading integrator of payment and information technology and services for intelligent travel solutions worldwide, and the leading...

  • SQL Database Administrator

    Found in: Whatjobs IN C2 - 7 days ago

    Hyderabad, India Vizlogic Digital Solutions Private Limited Full time

    Administration DBA should be familiar with the below activities...SQL Server ArchitectureInstallations and configurationsDatabase creations and configurationBackup and RestorationConnectivity Configuration and troubleshootingManaging securityMaintenance of databases-Re-indexing and update statisticsBasic knowledge about DB corruptionBasic Knowledge about...

  • SQL Database Administrator

    Found in: Whatjobs IN C2 - 2 weeks ago

    hyderabad, India Vizlogic Digital Solutions Private Limited Full time

    Administration DBA should be familiar with the below activities... SQL Server Architecture Installations and configurations Database creations and configuration Backup and Restoration Connectivity Configuration and troubleshooting Managing security Maintenance of...

  • SQL Database Administrator

    Found in: Talent IN C2 - 2 weeks ago

    Hyderabad, India Vizlogic Digital Solutions Private Limited Full time

    Administration DBA should be familiar with the below activities... SQL Server Architecture Installations and configurations Database creations and configuration Backup and Restoration Connectivity Configuration and troubleshooting Managing security Maintenance of...

  • Database Administrator

    Found in: Whatjobs IN C2 - 4 days ago

    Hyderabad, India MLOPS SOLUTIONS PRIVATE LIMITED Full time

    Position : SQL DBAExperience : 3+ yearsLocation : Hyderabadwork Mode : WFONotice Period : Immediate - 15daysRoles and Responsibilities :- Create new Microsoft SQL Server instances and configure them, including Always On availability groups and failover clustering- In charge of database backup and recovery methods, database access security and integrity,...

  • Database Administrator

    Found in: Talent IN 2A C2 - 5 days ago

    Hyderabad, India MLOPS SOLUTIONS PRIVATE LIMITED Full time

    Position : SQL DBAExperience : 3+ yearsLocation : Hyderabadwork Mode : WFONotice Period : Immediate - 15daysRoles and Responsibilities :- Create new Microsoft SQL Server instances and configure them, including Always On availability groups and failover clustering- In charge of database backup and recovery methods, database access security and integrity,...

  • Database Administrator

    Found in: Adzuna IN C2 - 5 days ago

    Hyderabad, Telangana, India MLOPS SOLUTIONS PRIVATE LIMITED Full time

    Position : SQL DBAExperience : 3+ yearsLocation : Hyderabadwork Mode : WFONotice Period : Immediate - 15daysRoles and Responsibilities :- Create new Microsoft SQL Server instances and configure them, including Always On availability groups and failover clustering- In charge of database backup and recovery methods, database access security and integrity,...

  • Database Administrator

    Found in: Whatjobs IN C2 - 4 days ago

    Bangalore,Hyderabad, India ADVANSOFT Full time

    About Fraank Systems:We're building for billions and crafting stories of bold transformation.The next-gen global technology company helping businesses to grow and thrive in the digital age.With the dynamic pace of technological change, choosing the right technology for business needs can be a complex and often confusing process.Fraank Systems approaches...

  • Database Administrator

    Found in: Adzuna IN C2 - 5 days ago

    Bangalore/Hyderabad, Karnataka, India ADVANSOFT Full time

    About Fraank Systems:We're building for billions and crafting stories of bold transformation.The next-gen global technology company helping businesses to grow and thrive in the digital age.With the dynamic pace of technological change, choosing the right technology for business needs can be a complex and often confusing process.Fraank Systems approaches...

  • Azure SQL Database Administrator

    Found in: Talent IN 2A C2 - 6 days ago

    Hyderabad, India YASH Technologies Full time

    Locations:: Indore, Pune, Hyderabad & BangaloreShift: 24/7 Primary Skills: Satisfactory knowledge of Cloud Computing (Azure or AWS)SQL Server provisioning, Patching, Backup and troubleshooting.Prepare and upload SOPS \ KB articles for SQL Servers, Azure SQLCoach team members on newer azure features \ services Has a good knowledge on assisting Senior...

  • Azure SQL Database Administrator

    Found in: Appcast Linkedin IN C2 - 6 days ago

    Hyderabad, India YASH Technologies Full time

    Locations:: Indore, Pune, Hyderabad & BangaloreShift: 24/7 Primary Skills: Satisfactory knowledge of Cloud Computing (Azure or AWS)SQL Server provisioning, Patching, Backup and troubleshooting.Prepare and upload SOPS \ KB articles for SQL Servers, Azure SQLCoach team members on newer azure features \ services Has a good knowledge on assisting Senior...

  • Database Administrator

    Found in: Whatjobs IN C2 - 2 weeks ago

    Bangalore,Hyderabad,Chennai,Vishakhapatnam,Vizag,Maharashtra, India Mouri Tech (P) Ltd Full time

    About MOURI Tech : MOURI Tech is a professional global enterprise solution provider helping its customers transform into intelligent enterprises. It offers comprehensive solutions and world-leading consulting and delivery experience to many fortune 500 companies across the globe. As a lead innovator of NextGen AI solutions, it enables its customers to...

  • Database Architect

    Found in: Whatjobs IN C2 - 2 weeks ago

    Hyderabad, India Gaian Solutions India Pvt. Ltd Full time

    Job Description : - Database Strategy and Architecture: Develop and maintain the overall database architecture, data models, and schemas for all database systems to ensure they meet business needs and performance requirements. - Solution Design and Implementation: Design, implement, and manage database solutions, including RDBMS, NoSQL database, data...

  • Database Architect

    Found in: Adzuna IN C2 - 7 days ago

    Hyderabad, Telangana, India Gaian Solutions India Pvt. Ltd Full time

    Job Description :- Database Strategy and Architecture: Develop and maintain the overall database architecture, data models, and schemas for all database systems to ensure they meet business needs and performance requirements. - Solution Design and Implementation: Design, implement, and manage database solutions, including RDBMS, NoSQL database, data...

  • Database Architect

    Found in: Talent IN 2A C2 - 2 weeks ago

    Hyderabad, India Gaian Solutions India Pvt. Ltd Full time

    Job Description :- Database Strategy and Architecture: Develop and maintain the overall database architecture, data models, and schemas for all database systems to ensure they meet business needs and performance requirements. - Solution Design and Implementation: Design, implement, and manage database solutions, including RDBMS, NoSQL database, data...

  • MS SQL Database Administrator

    Found in: Whatjobs IN C2 - 2 weeks ago

    hyderabad, India Telamon HR Solutions Full time

    Bachelor's degree in Computer Science or related field. Experience in database backup and recovery procedures. Ability to work independently and in a team environment. Strong experience with performance tuning and optimization. Microsoft Certified Solutions Expert (MCSE) certification is a plus. Experience with other database platforms like Oracle or...

  • MS SQL Database Administrator

    Found in: Talent IN C2 - 2 weeks ago

    Hyderabad, India Telamon HR Solutions Full time

    Bachelor's degree in Computer Science or related field. Experience in database backup and recovery procedures. Ability to work independently and in a team environment. Strong experience with performance tuning and optimization. Microsoft Certified Solutions Expert (MCSE) certification is a plus. Experience with other database platforms like Oracle or MySQL...