16 Always On Jobs

As an Infoscion, your primary role will involve interfacing with clients to address quality assurance issues and ensure high customer satisfaction. You will be responsible for understanding requirements, creating and reviewing designs, validating architecture, and delivering high levels of service offerings in the technology domain. Additionally, you will play a key role in project estimation, solution delivery, technical risk planning, code reviews, and unit test plan reviews. Guiding your teams towards developing optimized, high-quality code deliverables, continual knowledge management, and adherence to organizational guidelines will also be a significant part of your responsibilities. Your contributions will be essential in building efficient programs and systems to support our clients" digital transformation journey. In terms of technical requirements, you should have expertise in Database Administration, particularly in SQL and Oracle Database Administration. Experience in SQL DBA or Oracle DBA, including skills in Mirroring, Clustering, Log shipping, HADR activities, Always ON, RAC, RMAN, Dataguard, Exadata, and Golden gate, would be advantageous. A strong understanding of business domains, analytical abilities, technical skills, and excellent communication skills are essential. You should also possess knowledge of software quality assurance principles, SOLID design principles, and modelling methods, along with an awareness of the latest technologies and trends. Demonstrating problem-solving, analytical, and debugging skills is crucial. Additionally, you are expected to have knowledge of design principles, architecture fundamentals, performance engineering, quality processes, estimation techniques, project domains, and SDLC and agile methodologies. Your ability to translate functional and nonfunctional requirements into systems requirements, design and code complex programs, write test cases based on specifications, and collaborate effectively will be valued. Logical thinking, problem-solving skills, and staying updated on the latest technologies and trends are also important for this role.,

The primary responsibility of an Infoscion is to interface with clients for quality assurance issue resolution and ensure high customer satisfaction. You will be involved in understanding requirements, creating and reviewing designs, validating architecture, and delivering high levels of service offerings in the technology domain. Additionally, you will participate in project estimation, provide inputs for solution delivery, conduct technical risk planning, perform code reviews, and lead your teams in developing optimized high-quality code deliverables. Continual knowledge management and adherence to organizational guidelines and processes are essential. As an Infoscion, you are expected to contribute significantly to building efficient programs and systems. If you believe you have the skills to assist clients in their digital transformation journey, this role is ideal for you. A good understanding of SQL Database Administration and Oracle Database Administration is required, with experience in both being an added advantage. SQL DBA applicants should have experience in Mirroring, Clustering, Log shipping, HADR activities, and Always ON, while Oracle DBA applicants should be familiar with RAC, RMAN, Dataguard, Exadata, and Golden gate. In addition to technical requirements, Infoscion should possess analytical abilities, strong technical skills, good communication skills, and a sound understanding of software quality assurance principles, SOLID design principles, and modelling methods. Awareness of the latest technologies and trends is crucial, along with excellent problem-solving, analytical, and debugging skills. Further responsibilities include knowledge of design principles, fundamentals of architecture, performance engineering, quality processes, and estimation techniques. Infoscion should have a basic understanding of the project domain, the ability to translate requirements into systems requirements, design and code complex programs, write test cases based on specifications, and understand SDLC and agile methodologies. Logical thinking, problem-solving skills, and collaboration abilities are essential for this role. Preferred skills include expertise in Database Administration, specifically SQL DBA and Oracle DBA, as well as knowledge of MS SQL Server, SQL Server, and SQL administration in the technology domain.,

Role & responsibilities Knowledge on database objects, management tools. Good knowledge on writing T-SQL statements and creating of stored procedures, Functions and cursors. Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tool. To work on backups, restores and recovery models. Experience in High Availability (HA) like Failover clustering, always on, replication, Log shipping, Mirroring and Disaster Recovery (DR) options for SQL Server. Experience in Migration/upgrade and applying updates/patches. Implementation of security models. Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems. Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. Assist developers with complex query tuning and schema refinement. Should provide 24x7 supports for critical production systems. Perform scheduled maintenance and support release deployment activities after hours. Preferred Candidates Male Candidates

Primary Skills: MS SQL Server Administration: Production support, high availability configuration (AlwaysON), backups, recoveries, and security compliance. Database Design and Performance Tuning: Improving database design, indexes utilization, and queries performance tuning. Technical Leadership and Documentation: Serving as a DBA Technical Lead, developing and maintaining documentation, and ensuring delivery of assigned projects. Secondary Skills: AWS Hosting and Migration: Participating in database design, new server build, upgrade, and migration to AWS hosting. SSIS Packages: Maintaining and deploying SSIS packages per business requirements. Experience: In lieu of a degree, a combination of education and a minimum of ten (10) years of related work experience is required that provides the necessary skills and knowledge to perform all the essential job functions. Role and Responsibilities A. Key Responsibilities: Provide Database Administration production support for SQL Server Database business-critical systems. Production support of SQL Servers with AlwaysON in high availability configuration. New servers build as per BaseLine (Gold Image) and CIS benchmark. Serve as a DBA Technical Lead and Subject Matter Expert for Database projects, implementations, and tasks automation. Participate in application database design, new server build, upgrade, and migration to AWS hosting. Accountable for maintaining database backups and recoveries, and providing support for high availability systems in AlwaysON configuration. Work with developers and business users on improving database design, indexes utilization, and queries performance tuning. Develop and maintain proper documentation, including configuration specifics, and procedures for ongoing operation/maintenance. Accountable for security patching and cumulative upgrades of business-critical applications. Responsible for SQL Server Database stability, integrity, security compliance, and efficiency of the systems that support core functions of the business. Interact with senior engineers, management, vendors, and other stakeholders to identify areas of improvement. Maintain SSIS packages and perform deployments per business requirements. Accountable for ensuring delivery of all assigned projects and tasks, project implementation. Participate in the development and validation of Enterprise Business Continuity and Disaster Recovery plans. Maintain compliance with Security, Incident Management, and Change Management procedures. Maintain up-to-date knowledge of the IT industry as it relates to the technologies and processes in the Database domain, relevant organizational knowledge, and project management practices. Implement TDE, TLS 1.2, and maintain secure configuration and operation of SQL Server systems according to industry best practices. Participate in projects design discussions to ensure SQL Server Database designs are aligned with the Secure By Design philosophy, the architecture, and the current roadmap. SQL Servers version upgrades to the latest version. SSIS packages development and implementation. New servers build as per BaseLine (Gold Image) and CIS benchmark. Capacity planning. Disaster Recovery planning and execution. DB Backup/recovery implementation. Documentation. Participate in DBA on-call 24X7 support in the event of system outage or failure. B. Additional Responsibilities: Maintain compliance with all applicable federal, state, and local laws, regulations, and ordinances as well as policies, procedures, rules, and regulations applicable to the incumbent’s professional duties, responsibilities, and obligations. Educational Qualification: Equivalent combination of education and experience is considered. Certifications: Microsoft Certified: Database Administrator Associate

Role & responsibilities Associate should have L2 and L3 capabilities in different Versions of Microsoft SQL Servers. Installation of database software. Database Builds. Incident Management. Change Management. Problem Management. Database maintenance (Index re-build, table re-org). User Access Management. Database startup/shutdown. DBCC checks. Database re-org activities. Altering database/T-log files. Analyzing the database blocking. Analyzing session wait events. Perform database backup/restores. Migrating the database objects from Dev /QA to Production. Database refresh/cloning. Database upgrades. Database patching. Knowledge Management - Creation of SOPs for regular activities, KEDB. Knowledge on SOX/PCI Compliance reporting. DR Drill support. Always On. Azure Database Multiple node cluster adding knowledge in Power BI App Preferred candidate profile Minimum of 5-7 years of experience in Microsoft SQL Server Database Administration. Strong knowledge of Microsoft SQL Server 2016,2017,2019,2022 Administration. Ability to work in a fast-paced environment. Excellent communication, problem-solving skills, interpersonal, team member and leadership skills and abilities Perks and Benefits Competitive salary commensurate with experience, good health insurance coverage, epf, Bonus and Gratuity excellent work environment training and Certifications

Role & responsibilities Experience with Database Administration for MSSQL Server. Actively and consistently supports all efforts to simplify and enhance the customer experience. Designs and maintains access and security administration. Designs, implements and maintains backup and recovery strategies on Database Management Systems. Supports multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity and accessibility of data. Troubleshoots alerts (alert log, Jobs, Disk Group, Tablespace etc.) and performance issues. Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools Experience with backups, restores and recovery models. Experience with SQL in a virtualized environment (ESX and Azure). Knowledge of Always-On, High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server. Experience in implementing operational automation using scripts. Identify areas of the SQL environment that are suited for automation and then implement a solution using a variety of tools from applications such as HPSA or through scripting (PowerShell, TSQL). Knowledge of indexes, index management, and statistics. Experience working with Windows server, including Active Directory and proper disk configurations. Performs capacity planning of SQL server environment and provides recommendations to management to sustain business growth. Designs, implements, maintains Disaster Recovery (DR) methodologies and creates documentation. Gathers business requirements and designs, implements multiple projects along with the production support. Creates standard operational procedures and templates. Acts as mentor for Database Administrators and Associate Database Administrators. Performs research and provides plans to remediate complex business problems. Job Description: Redshift Expert in Redshift administration and AWS services like EC2,IAM ,CLoudwatch ,VPC.Manage and support 24x7 production as well as development databases to ensure maximum availability for various applications. Perform DBA related tasks in key areas of Cluster resizing ,Snapshot ,backup,restore object from snapshot ,ESSO SAML setup, Cloudwatch Monitoring , Performance ManagementWork in key areas of User Management,Access rights management , Security Management . Knowledge of day to day database operations,deployments and developmentsGood in designing ,implementing WLM/AUTO WLM by analyzing customer needs

Title: Senior Database Architect - Microsoft SQL Server Location: Gurgaon, India Type: Hybrid (work from office) Job Description Who We Are: Fareportal is a travel technology company powering a next-generation travel concierge service. Utilizing its innovative technology and company owned and operated global contact centers, Fareportal has built strong industry partnerships providing customers access to over 600 airlines, a million lodgings, and hundreds of car rental companies around the globe. With a portfolio of consumer travel brands including CheapOair and OneTravel, Fareportal enables consumers to book-online, on mobile apps for iOS and Android, by phone, or live chat. Fareportal provides its airline partners with access to a broad customer base that books high-yielding international travel and add-on ancillaries. Fareportal is one of the leading sellers of airline tickets in the United States. We are a progressive company that leverages technology and expertise to deliver optimal solutions for our suppliers, customers, and partners. FAREPORTAL HIGHLIGHTS: Fareportal is the number 1 privately held online travel company in flight volume. Fareportal partners with over 600 airlines, 1 million lodgings, and hundreds of car rental companies worldwide. 2019 annual sales exceeded $5 billion. Fareportal sees over 150 million unique visitors annually to our desktop and mobile sites. Fareportal, with its global workforce of over 2,600 employees, is strategically positioned with 9 offices in 6 countries and headquartered in New York City. Role Overview : We are looking for a highly skilled and enthusiastic Sr. Database Architect/Database Administrator. The responsibility of this individual will be focused on database design, data retention processes, data compliance, security, and automating related processes. We expect you to be proficient with automation and have expert-level knowledge of at least one database technology in our portfolio. This position requires a committed and self-motivated individual who can create and maintain data and schema designs for critical business processes, analytical projects and reporting infrastructure. You will help maintain our SQL reporting pipelines and procedures, their monitoring, as well as building out our data mart infrastructure. The right applicant will possess strong skills in latest technology and features used like SQL Server 2016+, Replication, Clustering, and Always-On. We are looking for individuals who are eager to learn and work in fast paced environment. Responsibilities: Manage and lead a team of DBAs in daily database operations. Design and develop scalable, efficient database architectures that align with business goals. Ensure the availability, reliability, and performance of SQL Server databases. Monitor and optimize database performance, proactively identifying and resolving issues. Implement backup and recovery procedures to ensure minimize data loss, with a strong focus on disaster recovery strategies. Develop and implement proactive monitoring and alerting systems to identify and address potential issues before they become critical. Configure and maintain database replication and high availability solutions, automating processes where possible. Manage database security, including user access, roles, and permissions. Develop and maintain comprehensive documentation for database systems, including standard operating procedures, policies, and standards. Collaborate with database engineers to ensure consistent and effective database design and implementation. Design and implement robust data models and schemas that support business requirements and facilitate data integrity. Implement automation for database deployment, maintenance, and monitoring tasks to enhance operational efficiency. Stay up-to-date with the latest SQL Server technologies and industry trends. Required Skills & Qualifications : Bachelor's degree in Computer Science or a related field. 8-10 years of experience in Microsoft SQL Server DBA operations. Experience with SQL Server 2016, 2017, 2019, and 2022 in Windows and Linux environments. Proficiency in database architecture skills, including: Data modeling and schema design, Indexing strategies and performance tuning and Partitioning. Strong automation skills, including, scripting for database deployment and maintenance, automating backup and recovery processes, Implementing CI/CD pipelines for database changes Strong understanding of SQL Server internals, including execution plans, Always On, replication, backup and recovery, and performance optimization skills. Experience in team leadership and mentoring. Excellent communication and collaboration skills. Strong analytical and problem-solving skills. Ability to work independently and in a team environment. Disclaimer This job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee. Fareportal reserves the right to change the job duties, responsibilities, expectations or requirements posted here at any time at the Companys sole discretion, with or without notice.

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