Job Details
Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:
Skills And Tools:
Job Description
- Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
- Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
- Independently analyze, solve, and correct issues in real-time, providing problem resolution end-to-end.
- Manage ETL and reporting environment on SQL server and will develop ETL and reports.
- Refine and automate regular processes, track issues, and document changes.
- Assist developers with complex query tuning and schema refinement.
- Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
- Monitor capacity to prevent unplanned outages grants permission to servers and databases in conjunction with standards as per the security team.
- Research, assess, and implement new features in SQL SERVER where appropriate and beneficial to the solution.
- Work with the Security team to manage access and compliance regularly review database and SQL instance permissions to make sure appropriate access is in place.
- Implement encryption and data masking options where required.
- Grant permission to servers and databases in conjunction with standards as per the Security team.
- Review SQL SERVER licenses for compliance as well opportunities to reduce costs.
- Cloud experience helpful.
- When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.
- Apply service packs/ DB Archive/ Capacity planning.
- Perform scheduled maintenance and support release deployment activities after working hours.
- Deciding whether clustering, log shipping, mirroring, replication, etc are the right fit to solve a business problem.
- Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention, and resolve them.
- Support software developers with database operations including the development of complex SQL, tuning of DML, and the creation of stored procedures.
- Learn relevant business processes and understand the data flow, criticality, and dependencies.
Job Requirements
Education:
- Bachelor's Degree in Computer Sciences / Information Technology or equivalent.
- Microsoft SQL Server Certification.
- MCTS, MCITP, and/or MVP certifications preferred.
Skills:
- Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
- Technical documentation skills.
- Ability to conduct research into database issues, standards, and products as required.
- Skilled in working with large volumes of data and loading data from multiple sources.
- Knowledge of reporting and query tools and practices.
- Knowledge of indexes, index management, and statistics.
- Skilled in deploying database change scripts.
- Skilled in performance optimization.
- Proven experiences with large data sets.
- Experience in BIG Data environments and Big Data tools advantageous.
- Strong understanding of SQL database structures, principles, and practices.
- Working technical experience with designing, building, installing, configuring, and supporting database servers, including Microsoft Clustered SQL Servers.
- Experience with replication (transactional or log shipping) required.
- On-call troubleshooting for SQL Server service outages.
- In-depth SQL Server Database Administration experience.
- Strong self-sufficiency and initiative working on Database projects.
- Experience Practical experience in monitoring and tuning a database to provide a high availability service.
- Experience in Transactional SQL, and DTS stored procedures.
- Practical experience in managing the internal and external MS SQL database security.
- 5 years of experience as a SQL Server DBA or similar role.
- 5 years of experience with MY SQL Server Administration experience are required.
- 5 years of experience with Performance Tuning and Optimization (PTO).
- 5 years of experience with backups, restores, and recovery models.
- 5 years of experience with Windows servers, including Active Directory
- Continuous improvement of processes and practices, automating processes where possible.
- Sense of ownership and pride in your performance and its impact on the company’s success.
- Critical thinker and problem-solving skills.
- Great interpersonal and communication skills.
- Prefer a candidate for Retail Experience.