DBA with MS SQL + Postgre

Key Responsibilities:

• 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.

Requirements:

• 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).

Preferred Qualifications:

• Knowledge of NoSQL databases and big data technologies.