Database Specialist
Job description
Database Specialist
Experience Required:5-10 years
Requirements:
- 10+ years of experience in database management and administration.
- Strong expertise inSQL Server, including database design, implementation, and optimization.
- Proven experience indata modeling,database tuning, and performance optimization.
- Hands-on experience withdata warehouseanddata lakesolutions (certification preferred).
- Proficiency inPythonfor database automation, scripting, and analysis.
- Certification inWindows serversadministration.
- Experience withETL toolsand processes for data integration.
- Strong knowledge ofdata visualizationtools (e.g., Power BI, Tableau).
- Excellent problem-solving skills and attention to detail.
- Strong communication and teamwork skills.
Preferred Qualifications:
- Experience in industries such as oil and gas, finance, or healthcare.
- Familiarity with cloud-based database solutions (e.g., AWS RDS, Azure SQL).
- Knowledge of big data technologies (e.g., Hadoop, Spark).
- Advanced degree in computer science, information systems, or a related field.
Skills
Key Responsibilities:
- Design, implement, and maintain robust database systems usingSQL Server, ensuring high performance, security, and scalability.
- Develop and optimizedata modelsto support business requirements and improve data integrity.
- Performdatabase tuningand optimization to enhance system performance and efficiency.
- Design and managedata warehouseanddata lakesolutions, including ETL (Extract, Transform, Load) processes.
- UtilizePythonfor database automation, scripting, and advanced data analysis.
- Administer and maintainWindows serversto ensure seamless database operations.
- Build and maintaindata visualizationtools and dashboards to support decision-making processes.
- Collaborate with cross-functional teams to understand data needs and deliver effective database solutions.
- Ensure compliance with data governance and security policies.
- Troubleshoot and resolve database-related issues, providing timely support to end-users.