Key Responsibilities
· Develop, maintain, and optimize SQL queries, stored procedures, views, functions, and triggers.
· Design and manage database structures to ensure data integrity, security, scalability, and performance.
· Write complex SQL queries for data extraction, transformation, validation, and reporting purposes.
· Create efficient reports, dashboards, and datasets to support business intelligence and operational requirements.
· Perform database performance tuning, query optimization, execution plan analysis, and indexing strategies.
· Develop and optimize joins, subqueries, CTEs, window functions, and aggregate queries for large datasets.
· Support data migration, integration, ETL, and data transformation activities across multiple systems.
· Collaborate with software developers, business analysts, and stakeholders to understand and implement data requirements.
· Troubleshoot and resolve database-related issues, including query performance bottlenecks and data inconsistencies.
· Monitor database health, performance metrics, and system availability to ensure reliable operations.
· Create, maintain, and update technical documentation for database objects, processes, and data flows.
· Ensure compliance with data governance, security standards, backup, and recovery procedures.
· Validate data accuracy and perform data quality checks using SQL scripts and automated processes.
· Assist in database deployment, release management, and production support activities.
Requirements
Qualifications
· Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
· 2–3 years of experience in SQL Development, Database Administration, or related roles.
· Strong understanding of relational database concepts and data modeling.
· Experience working with enterprise-scale databases and reporting environments.
Skills Required
· Strong proficiency in SQL programming.
· Experience with PostgreSQL, MySQL, Microsoft SQL Server, or similar RDBMS.
· Knowledge of Stored Procedures, Functions, Triggers, Views, and Indexing.
· Hands-on experience in query optimization and database performance tuning.
· Understanding of ETL processes and data transformation techniques.
· Proficiency in MS Excel and data analysis methodologies.
· Familiarity with Power BI, Tableau, or other reporting tools is an added advantage.
· Strong analytical, problem-solving, and communication skills.
Preferred Skills
· Experience with database backup, recovery, and security practices.
· Knowledge of cloud-based database platforms (AWS, Azure, or GCP).
· Familiarity with version control systems such as Git.
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
