Please mention DailyRemote when applying
AI Summary
The role involves managing MS SQL databases, focusing on query performance tuning, server optimization, and database monitoring. It also includes developing data warehouses using fact and dimension modeling and providing production support for various environments.
The candidate requirements are aligned more closely with MS SQL Database Engineer and DBA job descriptions:
- Advanced SQL query development
- Complex joins and subqueries
- Common Table Expressions
- Window functions
- Stored procedures and functions
- Views and triggers
- Query performance tuning
- Execution plan analysis
- Index optimization
- Table compression, data files, and file groups
- SQL Agent job management
- Database monitoring and troubleshooting
- Memory and server optimization
- Backup and restore support
- Data validation and reconciliation
- Data warehouse development
- Fact and dimension modeling
- Data quality monitoring
- Exception handling and root cause analysis
- Production support and incident resolution
- QA / DEV / PROD environment support
- Reporting investigation support
- Data modeling documentation
- Erwin data modeling tool experience
- Documentation and technical writing
- Problem-solving and analytical thinking
- Monitoring and operational support
- Ability to work independently
- Time and priority management
At Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.
Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.
We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.
Automatically Apply to the Best Remote Jobs
Stop the endless job search. Our AI finds and applies to the best jobs for you.
