9 Always On Jobs

Primary Skills : SharePoint : Extensive experience with SharePoint server configurations, including farm setup, architecture, administration, and troubleshooting. Experience with both SharePoint on-premises and SharePoint Online. Troubleshooting: Strong troubleshooting skills in both SharePoint and SQL Server environments . Azure : Hands-on experience with Azure-hosted environments, particularly for SharePoint deployments, including Front-End, Application, and SQL Database Servers. Farm Configuration : Knowledge of SharePoint farm architecture, managing multiple SharePoint environments (production, staging, DR, and development). API Integrations : Experience with .Net APIs and integration processes within SharePoint and other systems. Workflows : In-depth understanding and experience with SharePoint workflows (e.g., SharePoint Designer, K2 or Power Automate). Disaster Recovery (DR) : Strong experience with setting up and managing DR farms on Azure, including failover strategies, backup, and recovery. Proficiency in handling multiple websites hosted on different farms and ensuring their availability and performance. Secondary Skills: PowerShell: Advanced PowerShell scripting skills for SharePoint administration, automation, and reporting. Security: Knowledge of SharePoint security configurations, permissions, and user access controls. Version Control & Upgrades: Experience with SharePoint version upgrades and patches. Backup and Recovery: Expertise in SharePoint backup strategies and maintaining a high level of availability for SharePoint services. SQL Server : Expertise in SQL Server (20162019), particularly in Always On Availability Groups, database maintenance, performance tuning, and troubleshooting. Qualifications: Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent experience). Microsoft Certified: SharePoint Server Administration or related Microsoft certifications (e.g., Azure certifications) preferred. 5+ years of experience in SharePoint administration, with a focus on large, complex farms. Experience in managing multi-farm environments on Azure, including DR and Staging setups. Proven experience in SQL Server database administration, including Always On Availability Groups. Hands-on experience with SharePoint workflows, .Net API integrations, and website management. Experience in troubleshooting and resolving service requests.

5+ Years Strong background in SQL development combined with solid experience in AWS cloud services and Azure Data Factory (ADF) for building and managing data pipelines. Hands-on experience with high availability solutions such as Always On Availability Groups, database replication, and log shipping. Expert-level proficiency in T-SQL with hands-on experience in SQL Server 2016 or later, including query optimization and performance tuning. Strong programming skills in Python , particularly for scripting, data manipulation, and automation of data processes. Deep understanding of SQL Server backup and recovery models , with expertise in implementing disaster recovery strategies and best practices. Extensive experience with Microsoft BI tools , including SQL Server Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS). Proven ability to work in environments governed by data governance and compliance frameworks , ensuring secure and accurate data handling. Familiarity with Alteryx is an added advantage, though not mandatory.

Job Description: 24/7 support of production database services to ensure the highest standards of availability, integrity, security, and performance required by business systems. SQL Server Installation, good troubleshooting skills, Performance tuning (Table Partitioning). Experience in using tools like SQL Profiler, Performance Optimization, Extended Events, DMVs, Activity Monitor etc. Experience in Troubleshooting of High CPU, High memory, Slow IO and Deadlocks. Should have experience in Log shipping, Mirroring, Always on High Availability, Security and access control. Maintenance of back-ups recovery policies/procedures. Creation and maintenance of SQL queries and routines required for Administration, monitoring of DBs etc. Applying patches and perform DB Migrations in production environment as required. Reviewing and Tuning T-SQL Queries.

Exp: 8+ years Notice Period: Max 60 Days Max CTC: 18 LPA Primary skills: MS SQL DBA with High Availability (Always on) Required. Having experience of 8-9 years as MSSQL DBA. Hands on production experience on MSSQL. Hands on Backup and recovery methods. Experience in DR setup with hands-on experience in recoveries and DR Drills. Good knowledge in Mirroring, Log Shipping, Replication and Always on architecture concepts. Good knowledge in SQL Security Concepts. Good analytical skills to troubleshoot SQL day to day errors. Scripting knowledge would be beneficial. Good experience on Windows platform. Ready to work in 24*7 shifts.

• 3–7 years of SQL Server database administration experience. • Expertise in T-SQL, query optimization, and performance tuning. • Knowledge of backup/recovery, AlwaysOn, and high availability solutions.

Position Purpose This position is for Database (SQL Server) Administrator and to help technical and managerial support to the Local and Regional Database Environments. We are seeking a hands-on database administrator with a minimum of 8+ years of Industry experience. .. Responsibilities Direct Responsibilities 1. Responsible for installation, configuration and managing the database (MS SQL Server)servers and applying the security patches. 2. Remediating the vulnerabilities. Database performance tuning. 3. In addition, also provide and maintain the high availability (Clustering) and BCP/DR Recovery database solutions. 4. Responsible to develop ITIP Information Management Dashboards including risk analysis, current projects etc for different functions / clients. 5. Establish excellent working relationships with different functions across various regions. 6. Ensure rigorous follow up and communication to stakeholders on estimated delivery timelines of Projects 7. Analytical mindset in troubleshooting and resolving database problems 8. Good understanding in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools 9. Experience with backups, restores and recovery models. Contributing Responsibilities 1. Develop assess and select proper strategy for the projects considering performance, Cost, Time and Scope Constraints 2. Responsible to follow up and closing on all risk item identified by IG Audit or any other internal and external audits. Technical & Behavioral Competencies 1. SQL Server DBA with experience on Windows and Linux , PostgreSQL desirable 2. Working experience on Cloud is desirable. 3. Experience in core DBA, RAC and Dataguard implementation and monitoring activities and troubleshooting and Database Migration and upgrade activities.

1) Monitor generated log and event files indicating errors that will result in an incident 2) DR Database availability Monitoring 3) Monitor database log replication 4) Report Status of Log Replications as per agreed schedules 5) Session/Query/Log/Latch monitoring 6) Monitor the DB for failures and logged system events that indicate an imminent failure 7) Purging database Logs and trace files 8) Periodic config review to maintain consistent configurations 9) Review and recommendation to maintain availability 10) Monthly report on database availability 11) Monitor the DB for failures and logged system events that indicate imminent failure. 12) Reinstall Database software 13) Reconfigure log Shipping 14) Transaction replication Configuration 15) Link Servers configuration 16) Failover clustering 17) Always ON 18) Responding to database related incidents and driving corrective action 19) Tuning DB parameters 20) Correlate related incidents together into a problem ticket and manage through the problem management process 21) Use trend analysis to identify, detail, categorize, prioritize and create Problems Management Records. 22) Restoration of database 23) Creating jobs/job schedule for routine/Maintenance jobs & Rebuilding of indexes 24) Purging database Logs and trace files & Performance Management 25) Defragmentation of Database and performance tuning 26) Manage all Service requests through the change management process 27) Automate administration tasks where possible 28) Manage and update all Database environment documentation

Senior SQL Server DBA 9 to 12 Years of experience as an MS SQL Server DBA Lead or Similar role Work closely with Application Developers to design, test, implement, perfect, and maintain efficient transactional and analytical data models Lead/engage in tuning, upgrade, and configuration projects to enhance performance and ensure stability Optimize and keep backup jobs and schedules as well as maintain Production, DR, and Development environments Troubleshoot database and data issues as they occur Supply Ad Hoc data reporting and data pulls for Analytics teams Perform various ad-hoc data loading and data manipulation tasks Manage routine data exports for clients, partners, and SMEs Create and manage scheduled tasks and data processing scripts Document data collection, processing, and presentation procedures Help support architecture and process flow diagrams for data systems Participates in the evaluation, design, implementation, maintenance, support, and enhancement of sophisticated database systems and technologies. Manage all levels of database security and integrity, transaction activity, and utilization. Responsible for defining and documenting policies, procedures, and standards related to database administration. Responsibilities include troubleshooting database issues, recovery, tuning of the database, software installation, and resolving SQL Server errors and failures. Facilitate database backup and recovery as well as documenting and testing all backup and recovery procedures. Responsible for service level availability for all production and non-production SQL Server environments Required Technical and Professional Expertise Advanced skills and experience in database design, development, security, backup, recovery, performance tuning, and troubleshooting Leads and mentors junior DBAs, coordinates with other IT teams and communicates with stakeholders and clients. Maintain database integrity for cloud & locally hosted databases Setup Test, Dev, Staging, and Production Environments. (Installing SQL Server) Solve complex problems and develop a proof of concepts to validate ideas and technologies Perform in-depth system analysis, and recognize problems, opportunities, or underlying patterns and relationships. Create Linked Servers to SQL Servers and other databases such as Oracle, Access, Informix, etc. (Security and General Administration) Design database Backup and Restoration Strategy. (Database Backups and SQL Server Agent) Work as part of a team and provide 24x7 support Set up high availability as part of Disaster Recovery Strategy for the Databases. (Failover Clustering, Database Mirroring, Log Shipping and Replication, Always on) Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options), and query tuning. (Creating and maintaining those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity, etc) Documenting major changes to the SQL Servers. (General)

Hi, Greetings from CES LTD: Website Link : https://www.cesltd.com Headquarted AT : Chicago ( Illinois ) Certified AS : CMMI Level 5 Organisation Key Responsibilities: Administer, monitor, and maintain SQL Server environments across development, staging, and production systems. Lead migration projects from older SQL Server versions (e.g., SQL Server 2008, 2012) to modern versions (e.g., SQL Server 2019/2022 or Azure SQL). Perform schema and data migrations, ensuring integrity and minimal downtime. Tune SQL queries, indexes, and database configurations to improve performance and scalability. Develop and maintain backup, recovery, and disaster recovery strategies. Collaborate with application developers, DevOps, and infrastructure teams to support business-critical databases. Create and maintain documentation for database environments, procedures, and configurations. Participate in audits and enforce data compliance and security standards. Required Qualifications: Bachelors degree in Computer Science, Information Systems, or related fieldor equivalent experience. 5+ years of experience working with Microsoft SQL Server (2012 through 2022). Proven experience migrating SQL Server databases from legacy versions to newer platforms. Strong skills in T-SQL scripting, stored procedures, and SQL Server Agent jobs. Experience with SQL Server Performance Tuning and Optimization (PTO). Familiarity with SQL Server High Availability (HA) and Disaster Recovery (DR) technologies (e.g., AlwaysOn, clustering, replication). Understanding of security best practices (encryption, roles, access control). Strong troubleshooting and diagnostic skills. Preferred Qualifications: Experience with Azure SQL and cloud-based database services. Familiarity with tools such as SSIS, SSRS, or Power BI. Certifications such as Microsoft Certified: Azure Database Administrator Associate or MCSA: SQL Server. Exposure to automation tools or scripting languages (e.g., PowerShell, Python). Regards, Kanchana Senior Talent Aquisition Team CES LTD! www.cesltd.com