Database Adminitrator - Gurugram, India - Egon Zehnder

Description

The Company

Egon Zehnder ) is trusted advisor to many of the world's most respected organizations and a leading Executive Search firm, with more than 550 consultants and 63 offices in 36 countries spanning Europe, the Americas, Asia Pacific, the Middle East and Africa. Our clients range from the largest corporations to emerging growth companies, government and regulatory bodies, and major educational and cultural institutions. The firm is a private partnership which allows us to operate independent of any outside interests. As a result of this unique culture, Egon Zehnder has the highest professional staff retention rate for a global firm in our profession. We have a blue-chip client base across all industries and operate at the Board and senior management level.

Knowledge Centre India (KCI)

Established in January 2005, KCI in Gurgaon, works in close collaboration with the Global offices of Egon Zehnder. There are 5 teams that make up KCI: Research, Research Operations, Visual Solutions, Projects/CV Capture and Digital IT.

Your Journey at Egon Zehnder Starts Here

At EZ, you have the opportunity to deliver digital transformation initiatives across the globe for the organization. Our focus on emerging technology solutions along with our commitment to internal career growth and exceptional client value has resulted in a firm that is routinely recognized as a "Best Place to Work."

Who we are

We are part of Digital-IT team established 14 years ago in Gurgaon, India to provide technology support and rollout digital initiatives to 60 plus global offices. Digital IT has six key pillars – Collaboration Technology; Functional Technology; Digital Technology; Security & Architecture; Infrastructure & Services, Digital Success to support business and to take lead on digital transformation initiatives with the total strength of 150+ team members across the globe.

Requirements

Roles & responsibilities

Reports to DBA Team Manager

Duties include:

• Technical and functional knowledge mastery of EZ database applications, data flows, and business usages
• Evaluating architectures of EZ database systems against best practices and industry standards
• Advanced support for the EZ database infrastructure – incident and problem management, troubleshooting, and proactive potential problem identification
• Database development and partner in continued application development and support process development

Details

• Master the business-critical SQL Server environment from a support and future enhancements perspective. Work closely with developers to understand the technical and functional details needed to create support documentation.
• Provide 2nd/3rd level support for EZ SQL Server environment, including incident and escalations, problem management, and communication with internal customers for database-related problems.
• Direct ongoing performance tuning of EZ applications, including the design and development of database systems.
• Perform trend analysis and capacity management reporting with IT leadership and team members.
• Lead DB team involvement in the EZ customer care program, including continuously enhancing helpdesk and technical support processes, tools, and communication.

Position Requirements

• Three to five years' experience of MS SQL Server database administration
• Thorough understanding of database administration, operation, and maintenance activities.
• Thorough understanding of handling large OLTP databases (>1 TB) to support mission-critical business processes in a 24/7 production environment.
• Experience with SQL Server 64-bit architecture
• SQL Server Clustering (Active/Passive), Resource Groups, Failback strategies, Disaster Recovery
• SQL Replication technologies (Peer to Peer) & Merge
• Installation and patching of SQL Instances
• Hands-on support of the VLDB environment, including, but not limited to, ETL and data integration, data quality, and documentation
• Hands-on experience with SQL Server 2016 or above for backup/recovery, query tuning, indexing, SQL scripting, access and permission management, configuration tuning, physical database design, health, and performance monitoring, SQL scheduled jobs, maintenance plans, full-text indexes, replication, mirroring, log shipping, and point-in-time recovery.
• Able to work on SSIS, SSRS, PowerShell, SQLCmd and SQL Configuration Manager
• Automating, maintaining, and updating ongoing operational processes
• Good understanding of Windows 2012 or above operating systems, event logs, task scheduler, etc
• SQL Script creation for operations and development support
• Perform system optimization and continuous improvement planning, including SQL Server database performance analysis, capacity planning, system sizing, and ongoing maintenance/tuning
• Experience in the implementation of security policies and security audits
• Well organized and open to work as part of a global team
• Knowledge and experience of SSIS package development, Quest tools like Lightspeed, Red Gate SQL Tools, Azure managed SQL instance, Azure Data Factory, Azure Monitoring, and PowerShell programming will be a plus
• Highly motivated, goal-oriented, quick learner, and committed to the quality of deliverables, timelines and teamwork
• Continuous learning and skill enhancement is of high importance.
• ·Excellent verbal and written communication skills

Education & Certification

• Bachelor's degree, preferably in Computer Science, Engineering or related discipline
• Microsoft Certified SQL Database Administrator

Benefits

Benefits which make us unique

At EZ, we know that great people are what makes a great firm. We value our people and offer employees a comprehensive benefits package. Learn more about what working at Egon Zehnder can mean for you

Benefits Highlights:

• 5 Days working in a Fast-paced work environment.
• Work directly with the senior management team
• Reward and Recognition
• Employee friendly policies
• Personal development and training
• Health Benefits, Accident Insurance

Potential Growth for you

We will nurture your talent in an inclusive culture that values diversity. You will be doing regular catchups with your manager who will act as your career coach and guide you in your career goals and aspirations.

Location

The position is based at Egon Zehnder's KCI office in Gurgaon, Plot no. 29, Institutional Area Sector 32

EZ Commitment to Diversity & Inclusion

Egon Zehnder aims for a diverse workplace and strives to continuously lead with our firm values. We respect personal values of every individual irrespective of race, national or social origin, gender, religion, political or other opinion, disability, age and sexual orientation as warranted by basic rights enshrined in the UN Declaration of Human Rights. We believe diversity of our firm is central to the success and enables us to deliver better solutions for our clients. We are committed to creating an inclusive environment and supportive work environment, where everyone feels comfortable to be themselves and treated with dignity and respect and there is no unlawful discrimination related to employment, recruitment, training, promotion, or remuneration.

Egon Zehnder is an Equal Opportunity Employer

Egon Zehnder provides equal employment opportunities to all applicants and employees without regard to race, color, creed, religion, sex, sexual orientation, gender identity, marital status, citizenship status, age, national origin, disability, or any other legally protected status and to affirmatively seek to advance the principles of equal employment opportunity.