- Database Development and Administration:
- Design, implement, and maintain database structures according to best practices for performance and reliability.
- Monitor database performance, implement changes and apply new patches and versions when required.
- Ensure database security, integrity, stability, and system availability.
- Administer database access permissions and privileges.
- SQL Development:
- Develop and optimize complex SQL queries, stored procedures, functions, and scripts for various business applications.
- Troubleshoot and resolve database performance issues, optimizing SQL code for maximum efficiency and speed.
- Collaborate with developers to integrate databases with existing systems and applications, providing SQL expertise.
- Data Extraction and Analysis:
- Extract, transform, and load (ETL) data from various sources for analytical reporting and insights.
- Develop strategies for data acquisitions, archive recovery, and implementation of a database.
- Work closely with data analysts and business stakeholders to understand data requirements and deliver comprehensive data reports and visualizations.
- Maintenance and Support:
- Provide 24/7 support for critical database issues and performance bottlenecks.
- Plan and execute regular database backups and recovery procedures.
- Document database architectures, procedures, and processes for reference and compliance purposes.
- Bachelor's degree in Computer Science, Information Technology, or related field.
- 5+ years of proven experience in SQL development and database administration.
- Strong knowledge of SQL Server, Oracle, or other relational database management systems.
- Experience with data modeling, ETL processes, and business intelligence tools.
- Proficiency in writing complex SQL queries and optimizing them for performance.
- Familiarity with database security practices and disaster recovery techniques.
- Excellent problem-solving skills and attention to detail.
- Strong communication and collaboration abilities to work effectively across different teams.
- Ability to manage multiple projects and meet tight deadlines.
- Experience with cloud-based database services (e.g., Azure SQL Database, Managed Instances).
- Knowledge of NoSQL databases and big data technologies.
DBA with MS SQL + Postgre - Kerala, India - Netstager Technologies Pvt Ltd
Description
Key Responsibilities:
Requirements:
Preferred Qualifications: