SQL Server DBA Jobs

Required Qualifications & Skills:Technical Skills: 5+ years of experience as a Production SQL Server DBA. Expert-level knowledge of SQL Server (2016, 2019, 2022). Must have proven experience in configuring and managing SQL Server Replication (Transactional, Merge, Snapshot) across multiple geographic locations. Strong expertise in SQL Server High Availability (HA) and Disaster Recovery (DR) solutions. Proficiency in performance tuning, query optimization, and troubleshooting. Experience in SQL Server security, encryption, and compliance. Strong skills in PowerShell scripting, T-SQL, and automation.Soft Skills: Strong problem-solving and analytical skills. Ability to work independently and manage multiple priorities. Excellent communication and documentation skills. Experience working in 24/7 production environments. Strong teamwork and collaboration with cross-functional teams.

!!! Vikhroli, Mumbai Work from Office Fulltime

SUMMARY OF RESPONSIBILITIESThe successful person for this role will be highly experienced in SQL Server administration. They will have experience with: High-Availability design and builds using technologies SQL Server Failover Clusters Database, system and application performance tuning Replication and Cloning Design and Solutions Database upgrades and migrations Backup recovery plans and execution Data integration (SSIS), analytics (SSAS), business intelligence (SSRS), and visualization. SQL Server on Azure: - IaaS and PaaS

Urgently Requirement for DBA Developers, with having 3 to 5 yrs of work experienceLocation Noida

Monitoring system performance and identifying problems that arise.Responding in a timely manner to user-reported errors.Protecting the database against threats or unauthorized access.Ensuring that the database is adequately backed up and able to be recovered in the event of memory loss.Reporting on metrics regarding usage and performance.Suggesting changes and improvements for database maintenance or protection.Regularly liaising with IT project managers and database programmers.Designing databases with both front-end and back-end users in mind.

.Database Engagement in AWS Schema Optimization, Data Capture, Roles Mapping Scope 2019 MS SQL servers are EC2 instances on AWS, (no RDS). Setup change data capture for FIMMAS database. 1. The FIMMAS databases use unique indexes and have no keys, making this a very manual setup.2. About 1100 tables. Schema optimization, to towards segmentation of data 1. Create schemas. 1. Analysis of separation2. Create schemas2. Transition CRUD views 1. Analysis of need views and what schema they should go under2. Create views. Roles mapping to schemas to provide better granularity on security. 1. Creation of roles for each schema 1. CRUD2. View Def3. Execute2. Identify common grouping of roles. Security create AD groups map to roles. Security clean-up and get added to attestation system. 1. Walking SR/CRs through IAM.2. Analysis for linking to attestation/AD groups Structure complete partitioning. 1. Define common indicators for horizontal partitioning2. Create jobs to trigger movement. Ensure optimization routines are scheduled and running (scripts). Enable database email functions. Cleanup code structure so script extracts are readable. Issues and need - 1. Get well defined code structure.2. Low level tech goes through every view and Stored proc and makes adjustments or confirms.3. There are about 420 scripts current, it might double when Wynsure views get added. Design process to load data from UAT to lower environment. Issues and need - 1. Keep lower environment security in place. 2. Have processes but the build out takes time, and confirmation of timing when it is ran.3. Documenting the process so someone who comes after can run. Setup auto rerouting of connection to and between Prod Read Only Prod. 1. Current setup has non-clustered read only replicas.

Strong command of SQL and SQL server tools. Advanced knowledge of database security, backup and recovery, and performance monitoring standards Understanding of relational and dimensional data modeling. PowerShell scripting skills. Familiarity with SSAS, SSIS, SSRS Excellent written and verbal communication skills Impeccable attention to detail. MCSE/MCSA certifications preferred. Experience with Linux and Windows Server environments. Extensive experience with database technologies in MSSQL. Experience with cloud services (AWS, Microsoft Azure) a plus. Assist with schema design, code review, SQL query tuning. Install, implement and upgrade DBMS installations. Write and deploy SQL patches. Upgrade and improve application schema and data upgrades. Must have extensive and proven troubleshooting and administration experience in large and mission critical enterprise environments. Must have good knowledge on high availability features like log shipping, Clustering, Replication. Specialized Data Handling. Capacity Planning. Performance Monitoring. Exposure to MySQL, Oracle, MongoDB are added advantages.

Roles and Responsibilities1. Good understanding of SQL Server Architecture, Memory handling.2. Strong knowledge and hands on expertise in below areas:SQL server stored procedures(a) Functions(b) Triggers(c) SQL jobs(d) Performance tuning(e) Writing and reviewing T-SQL code.3. Day-to-Day Production DB support and maintenance of MS SQL server.4. Perform Database system optimization and improvement and query optimization.5. Plan and maintain Database Archiving6. Assisting Application team in detecting performance problems.7. Basic understanding of database development cycle8. Backup and recovery from Backup.9. Knowledge of database index management, statistics update.10. Should be hands-on in writing SQL queriesDesired Candidate ProfileGood to have Hands on experience on Database Mirroring, Log Shipping, Replication and Always-on in all SQL versions

SQL Database administrator who can independently. Client confirmation has not come yet/