Workplace Options
Website:
workplaceoptions.com
Job details:
Workplace Options:
Workplace Options [WPO]: Founded in 1982, WPO is the largest independent provider of holistic wellbeing solutions. Through our customized programs, and comprehensive global network of credentialed providers and professionals, we support individuals to become healthier, happier and more productive both personally and professionally. Trusted by 51% of Fortune 500 companies, we deliver high quality care digitally and in-person to over 75 million individuals across 116,000 organizations in more than 200 countries and territories. At WPO, you will be joining a team that is committed to improving employee wellbeing around the world.
WPO is looking forward to take their technology investments to next generation with cutting-edge integration platforms based on Cloud technologies. Selected candidates will have opportunity to work with a great technology team, diverse across globe.
Job Description: DBA Specialist
Workplace Options (WPO) requires DBA Specialist to help in Data Architect to design and implement enterprise-wide data architecture frameworks and strategies.
The candidate will succeed in the role based on how the candidate is ‘easy to work with’. The below determines ‘easy to work with’:
- Demonstrate courteousness and respect to people across diverse cultures, age groups and varied business groups
- Ability to communicate efficiently with business teams
- Communicate the design principles and process
- Transparently convey the status, challenges, architecture methods of integration projects.
Role Summary & Expectations:
As a SQL Server & Database Administrator, you will be responsible for monitoring and maintaining database health, optimizing performance through query tuning and indexing, ensuring reliable backup and disaster recovery procedures, and automating routine tasks while maintaining comprehensive documentation.
- Installation & Configuration: Install, configure, and maintain SQL Server instances with regular maintenance tasks
- Monitoring & Health Management: Monitor database health and set up comprehensive alerting using SQL Server Agent and third-party tools
- Performance Optimization: Analyze and optimize queries; design indexing strategies and tune parameters to resolve bottlenecks
- Backup & Disaster Recovery: Execute regular backups and develop comprehensive disaster recovery procedures with failover testing
- Security & Compliance: Manage access controls and implement database encryption (TDE, Always Encrypted) ensuring GDPR/HIPAA/SOX compliance
- High Availability & Replication: Design high availability solutions (Always-On Availability Groups, Failover Clustering) and manage replication
- Cloud & Multi-Database Support: Manage Azure SQL Database, elastic pools, and support MongoDB, MySQL, PostgreSQL environments
- ETL & Reporting: Schedule and monitor ETL jobs; configure report subscriptions and delivery mechanisms
- Automation & Documentation: Develop PowerShell scripts and maintain comprehensive database architecture documentation
Role Requirements:
- Overall 7+ years of experience in Database Administration & Database Design.
- SQL Server Expertise: Strong expertise in SQL Server (2012, 2014, 2016, 2019, 2022) and Proficiency in T-SQL programming and query optimization
- Database Management & Tools: Hands-on experience with SSIS (ETL), SSRS (reporting), SSMS, and SQL Server Agent
- Cloud & Multi-Database Support: Azure SQL Database and cloud management; experience with MongoDB, MySQL, or PostgreSQL
- Database Design & Operations: a) Relational database design, normalization, high availability (Always-On, Failover Clustering) b) Backup, recovery, disaster recovery, performance monitoring, and database security/encryption - Modern Data Stack & Cloud Platforms (Preferred): Experience with Snowflake, Databricks, BigQuery and cloud platforms (Azure, AWS, GCP).
- Certifications (Preferred): Microsoft Certified Data Administrator Associate or SQL Server certifications, Azure Data Administrator or Azure Solutions Architect certifications
- Data Architecture & Warehousing (Preferred): Knowledge of data warehousing, dimensional modeling, data lakes, and Lakehouse architecture.
- ETL/ELT & Integration (Preferred) : Background in ETL/ELT processes and data integration platforms.
- Automation, Monitoring & Governance (Preferred): PowerShell scripting, third-party monitoring tools (Redgate), and enterprise-scale data governance programs.
What we offer:
At Workplace Options, we don’t just deliver wellbeing services to our clients, we champion wellbeing for our own employees as well. Examples of our benefits and commitment to employee wellbeing include:
Benefits - Group Mediclaim Insurance for 6 lacs INR, Accident Insurance, Gym reimbursement, Tuition reimbursement, EAP Support Services, Mentorship program, WPO Cares, Employee exchange program, Comprehensive training provided for this position
At Workplace Options, we are committed to and are accountable for building a workplace where individuals feel empowered to bring their whole selves to work, free from judgment or fear of discrimination. We understand that having a diverse organization is only the beginning and it will require nurturing and care to thrive. We will continue to take action to ensure we achieve equitable and measurable outcomes.
We strive to cultivate a space where diverse voices are not only heard but actively sought out and valued for the unique insights they bring. By embracing and promoting authenticity, we aim to build a vibrant and inclusive community that fosters collaboration, innovation, belonging and personal growth.
For further details about WPO please check out our website www.workplaceoptions.com and these short videos give a great overview of what we do Human-Powered Care and The WPO Global Experience
Workplace Options collects and processes personal data in accordance with applicable data protection laws. If you are a European job applicant, refer to our Privacy Notice for further details (https://www.workplaceoptions.com/privacy-notice-for-recruitment/).
Click on Apply to know more.