SQL DBA Expert

6 days ago

Andhra Pradesh, India Xpert Conexions Full time

Job Description :

- Perform secondary administration tasks on MongoDB, Azure PostgreSQL, and Azure MySQL.

- Design, implement, and maintain database systems to ensure high levels of performance, availability, and security.

- Develop and execute comprehensive database backup and recovery plans.

- Monitor database performance and optimize queries for efficient data retrieval.

- Ensure database systems meet business and performance requirements.

- Collaborate with development teams to design and implement robust database solutions.

- Troubleshoot and resolve database issues, providing timely and effective solutions.

- Document database procedures and policies, ensuring compliance with industry standards.

- Extensive knowledge and hands-on experience in database administration.

- In-depth understanding of Azure SQL PaaS database and Managed instance capabilities and features.

- Proficiency in writing and maintaining PowerShell scripts for database automation

- Design, implement, and maintain large-scale distributed databases that handle big data.

- Optimize database performance for efficiency and scalability.

- Ensure data integrity and security within the databases.

- Install and configure big data technologies, such as Hadoop, NoSQL databases, and other distributed computing systems.

- Monitor database performance, troubleshoot issues, and optimize query performance.

- Implement performance tuning and optimization strategies to ensure efficient data processing.

- Experience in large and complex databases in SQL Server 2019,2017,2014,2012, SQL Server 2008 R2

- Experience in Installation and configuration of SQL Server 2008 R2, 2012,2014,2016,2017,2019

- Technical proficiency in handling Microsoft SQL Database related issues both in production and non-production environments with expertise in doing rigorous troubleshooting on Database Backup, Restore, Log shipping, Database Mirroring and Always on etc.

- Experienced in scheduling Backups, Restore and Maintenance plans using Native tools.

- Experienced in using different Recovery models Simple, Full and Bulk-logged depending on

Application requirement :

- Good experience configuring the index creation and maintenance activities on indexes.

- Slow running queries and helping in improving the performance.

- Restoring the Databases from Prod to Test.

- Troubleshooting blockings, deadlocks, disk space issues and fixing them by adding permanent fixes.

- Running the maintenance activities like update-statistics and DBCC CHECKDB at the time of performance issues

- Creating and managing the users and permissions and fixing the orphan users.

- Configured and maintained Transactional Replication and troubleshooting and adding articles to the existing replication.

- Good experience configuring and maintaining Log shipping and Mirroring.

- Hands on experience in Migration of SQL Server and databases from old version to new version.

- Configured and maintained Active/Passive clustering for failover. And performing patching as well.

- Configuring Always-ON in SQL Server 2012/2014 and adding and removing Databases to existing HADR Availability Group.

- Troubleshooting slow running queries.

- Good to have Knowledge in SSIS and SSRS configuration and migration of packages and migration reports.

- Develop and implement backup and recovery strategies to safeguard data in case of failures or disasters.

- Test and document recovery procedures to minimize downtime.

(ref:hirist.tech)

  • SQL Dba

    3 days ago

    Noida, Uttar Pradesh, India Technology Next Full time

    **SQL DBA (6-8 Years Experience)** **Locations**: Bangalore | Hyderabad | Pune | Noida | Gurgaon | Chennai (Hybrid) **Type**: Contractual / 6 months **Role Overview**: We are seeking an experienced **SQL Database Administrator** with 6-8 years of expertise in managing, maintaining, and optimizing enterprise-scale SQL databases across hybrid...

  • Ms SQL Dba

    1 week ago

    Andhra Pradesh, India Virtusa Full time

    MSSQL DBA admin JD In depth knowledge of database design, normalization, indexing, and query optimization. Hands-on experience with SQL server installation, service pack upgrades, and migration. Strong experience with relational database management systems, focusing on MSSQL Server Always On and Azure, AWS services. Proven experience in backup recovery...

  • Ms Sql Dba

    1 week ago

    Andhra Pradesh - Hyderabad, Telangana, India Diverse Lynx Full time

    Position- MS SQL DBA Exp - 4 Years Location- Chennai Hyderabad Kolkata Ahmedabad JD - Installation Configuration and Up gradation of Microsoft SQL Server Databases Instance Configuration and Maintenance Troubleshooting different types of database related problem backup related problem Error log checking Database Security Logins and jobs creation...

  • SQL Dba

    2 weeks ago

    Noida, Uttar Pradesh, India cyanous Full time

    **Job Description-** - SQL DBA with support experience required in Microsoft technologies like Windows Server, MS SQL Server, AD, GPOs, Registry, Windows Logs, Server performance monitoring, MS Office and Patching etc. PowerShell knowledge - Should have knowledge of MS SQL Replication and other basic components of SQL Server. - Should be good in writing and...

  • Principal Consultant – SQL DBA

    21 hours ago

    uttar pradesh, India Genpact Full time

    Principal Consultant – SQL DBALocation: Bangalore/ Hyderabad/ Delhi NCRExperience: 8-15 yearsImmediate joiners preferred.Second round will be a F2F.Key Skills: SQL DBA, AWS, SQL Server Always OnKindly share resume to Sreenivas.Karanam@genpact.com with sub of "SQL DBA" along with notice period. Genpact is hiring a senior SQL DBA who will be responsible for...

  • SQL Dba

    1 hour ago

    Bhopal, Madhya Pradesh, India Ruchi Security Printers Pvt Ltd Full time

    **Full Job Description**: Your responsibility as a database administrator (DBA) will be **the performance, integrity and security of a database**. You'll be involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users. You'll ensure that: data remains consistent across the database. **Database...

  • Oracle DBA with MongoDB_Hyderabad, Chennai, Kolkata

    2 weeks ago

    Andhra Pradesh, India Tata Consultancy Services Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Greetings from TCS TCS Hiring for Oracle DBA with MongoDB Job Location: Hyderabad, Chennai, Kolkata Experience Range: 8-12 Years Job Description :Proven experience as a Sr. Oracle DBA Oracle - Experience in GoldenGate , RAC , PL/SQL , experience Data Archival strategies Proficiency in programming languages like Bash, Python, and Perl Excellence in...

  • SQL Dba

    2 weeks ago

    Noida, Uttar Pradesh, India Thales Full time

    Location: Noida, India Thales people architect solutions that enable two-thirds of planes to take off and land safely. We create in-flight entertainment systems that engross 50 million fliers every year and we develop the avionics that control the world’s largest commercial aircrafts. Our simulators train the next generation of pilots for fighter jets,...

  • Oracle Dba

    1 week ago

    Andhra Pradesh, India Virtusa Full time

    Install, configure, and upgrade Oracle databases, MySQL, and PostgreSQL. Monitor database performance and implement tuning strategies to enhance efficiency. Implement backup and recovery solutions to safeguard data integrity. Manage user access and security protocols across all database systems. Troubleshoot and resolve database issues and performance...

  • Mongodb Dba

    3 weeks ago

    Hyderabad, Telangana - Madhya Pradesh, India CIEL HR Full time

    Position Title MongoDB DBA Required Experience 5 - 8 YearsSalary Band in INR 22 - 30 LPAJob Location Hyderabad IndoreWork Timings Shift 24x7 based on project requirement Job Summary Roles Responsibilities Experience on Installation configuration and upgrading MongoDB software and products Creating and sizing database storage structures and...