Database Developer + DBA

Key Responsibilities:

Database Development:

• Design, develop, and optimize database schemas, tables, views, stored procedures, and triggers using SQL Server, MySQL, and PostgreSQL.
• Develop and maintain ETL (Extract, Transform, Load) processes to support data integration and reporting needs.
• Build efficient, scalable, and secure database architectures to support software applications and services.
• Write complex SQL queries to extract, manipulate, and report on data as required by business needs.
• Implement and optimize indexing strategies for improved database performance.
• Collaborate with software development teams to integrate databases with applications and ensure seamless data flow.

Database Administration:

• Perform installation, configuration, and maintenance of database servers, ensuring optimal performance and uptime.
• Monitor and troubleshoot database performance, resolving bottlenecks and optimizing system efficiency.
• Implement and maintain backup and recovery strategies to safeguard data integrity and ensure high availability.
• Automate database maintenance tasks using scripts and automation tools to reduce manual overhead.
• Set up and monitor replication, clustering, and high availability solutions to ensure data consistency across environments.
• Conduct capacity planning and provide recommendations for hardware and software upgrades.

Security & Compliance:

• Implement robust data security protocols, including user access management, encryption, and auditing.
• Ensure compliance with data protection regulations (e.g., GDPR, HIPAA) and internal data security policies.
• Perform regular database audits to identify and mitigate security vulnerabilities.

Additional Responsibilities:

• Create and maintain technical documentation for database designs, configurations, and maintenance procedures.
• Conduct data migration and upgrade projects, ensuring smooth transitions with minimal downtime.
• Assist development teams in optimizing query performance and identifying areas for database tuning.
• Support DevOps initiatives by integrating databases into CI/CD pipelines using tools like Jenkins, GitHub Actions, or Azure DevOps.
• Stay updated on the latest database technologies, open-source tools, and industry best practices.

Required Skills & Qualifications:

• Bachelors degree in Computer Science, Information Technology, or related field.
• 5+ years of hands-on experience with SQL Server, MySQL, and PostgreSQL.
• Strong experience in database design, development, optimization, and performance tuning.
• Expertise in writing complex SQL queries, stored procedures, functions, and triggers.
• Proficient in database backup, recovery, and disaster recovery planning.
• Experience with ETL processes, data warehousing, and data integration.
• Knowledge of data security protocols, encryption techniques, and compliance requirements.
• Hands-on experience with Linux and Windows server environments.
• Familiarity with cloud database services on AWS (RDS), Azure, or Google Cloud.
• Strong analytical and problem-solving skills with attention to detail.
• Excellent communication skills and ability to collaborate with cross-functional teams.

Nice-to-Have Skills:

• Experience with NoSQL databases like MongoDB or Redis.
• Knowledge of containerization technologies (Docker, Kubernetes) for database deployment.
• Familiarity with automation tools like Ansible or Terraform.
• Experience in Python or Shell scripting for database automation.
• Understanding of data visualization and reporting tools (e.g., Power BI, Tableau).

Personal Attributes:

• Strong ability to multitask and handle multiple projects simultaneously.
• High level of attention to detail and commitment to data accuracy.
• Ability to work independently and proactively troubleshoot database issues.
• Eagerness to continuously learn and adapt to new database technologies.