Database Developer

As a Database Developer, you will design, develop, and optimize database solutions for enterprise and SaaS platforms. You will be responsible for building efficient and scalable data systems, writing and tuning SQL queries, supporting backend integration, and ensuring data integrity and performance. You will collaborate with product, DevOps, and QA teams, contribute to documentation, and continuously improve your skills in cloud, automation, and modern data engineering practices.

Essential Functions / Deliverables:

• Database Architecture, Design & Development:
• Design relational and distributed database schemas for scalability, performance, and normalization
• Develop and maintain SQL queries, PL/SQL packages, stored procedures, views, triggers, and functions
• Define and enforce data modelling standards
• Support both OLTP and OLAP environments

Performance Tuning & Optimization:

• Perform advanced query tuning, indexing strategies, and plan analysis
• Identify and resolve bottlenecks and slow queries
• Optimize large-volume transactions and reporting performance across databases
• Automate monitoring and alerting of performance issues

Database Administration and Environment Management:

• Manage deployments, patches, backups, restores, and upgrades of Oracle/PostgreSQL/MySQL environments
• Implement high-availability and failover solutions
• Ensure data security, access controls, and audit readiness
• Assist with replication and data migration strategies

Backend and Full-Stack Integration:

• Work with backend developers (Dot Net Core, Dot Net Framework, Python, Java) to integrate database logic into applications
• Design and consume RESTful APIs to facilitate secure data exchange
• Participate in full-stack development with occasional involvement in frontend tasks (HTML/CSS/JS)

Cross-functional Collaboration:

• Collaborate with QA, DevOps, Product Managers, and UX teams
• Translate business requirements into technical specifications
• Participate in agile ceremonies such as sprint planning, retrospectives, and demos

Documentation, Standards & Governance:

• Create and maintain technical documentation, ER diagrams, SOPs, and version history
• Promote database best practices, naming conventions, and change control policies
• Contribute to SKO's internal knowledge base and technical wiki

Cloud Data Strategy & BI Tool Integration:

• Prototype and recommend cloud-native DB solutions (e.g., AWS RDS, Azure SQL, GCP Cloud SQL)
• Integrate with BI/reporting platforms (SSRS, Power BI, Metabase)
• Develop ETL/ELT data pipelines for analytics initiatives

Continuous Improvement and Learning:

• Participate in code reviews and peer learning
• Identify skills gaps and seek training opportunities
• Contribute to proof-of-concept initiatives and tech evaluations
• Stay updated on trends in database development, cloud, and automation

Nice to have:

• Linux Environment & Shell Scripting and Cloud & BI Tool Experience will be an added advantage
• Support database operations in Linux environments
• Write and maintain shell scripts for automation

AI & Automation in Data Engineering (Improvement):

• Explore and adopt AI-powered tools for query optimisation, anomaly detection, and documentation
• Automate repetitive database tasks using scripts and modern tools
• Experiment with AI-driven analytics and reporting
• Share insights and promote innovation in database practices

Requirements:

• Education: Bachelor's degree in Computer Science, Engineering, or a related field
• Certifications (Preferred): Certifications in Oracle / PostgreSQL / AWS / GCP
• Required Professional Experience:
• 5-7 years of hands-on database development experience in enterprise or product-based environments
• Experience working in Agile or DevOps-based teams
• Technical/Computer Skills:
• Database Platforms: Oracle, MySQL, SQL Server (others a plus)
• Languages: SQL, PL/SQL, T-SQL, Python, Java (basic)
• Frameworks/Tools: REST APIs, SSRS/SSIS, Shell Scripting, Git
• Operating Systems: Windows, Linux (preferred)
• Skills: Query optimisation, ER modelling, backup & recovery, source control, Agile development tools (ADO, Confluence)

Professional competencies:

• Strong analytical, debugging, and problem-solving skills
• Excellent verbal and written communication
• Ability to collaborate with cross-functional teams
• Deep expertise in relational database theory, design, and architecture

Behaviour and Social competencies:

• Deep expertise in relational database theory, design, and architecture
• Strong problem-solving and troubleshooting skills
• Ability to manage priorities in a fast-paced, multi-tasking environment
• Clear communication and documentation skills
• Capability to work independently and in collaborative environment
• Strong sense of ownership, business acumen, leadership mindset, and accountability
• Willingness to contribute to the company's product growth and development culture

Ethics & Compliance:

This position demands the highest standard of integrity and ethical behaviour. The candidate must promote compliance in handling data and implementing security policies. It is expected to report or speak up about risks, compliance gaps, or ethical concerns in the team or systems.

Skills

Database, Java, MySQL, Oracle, PL/SQL, Python, SQL, SQL Server, T-SQL