Job
Description
As a Database Analyst / SQL Developer, your role involves developing, testing, and maintaining SQL queries, stored procedures, functions, and views in Oracle and SQL Server. You will be responsible for reading from and writing to database tables for business logic processing and reporting. Additionally, you will design and optimize joins, subqueries, and complex data retrieval logic. Your expertise will be crucial in analyzing existing database structures, recommending optimizations, and ensuring data quality and integrity across systems. You will create and maintain scheduled jobs, ETL processes, or data pipelines while collaborating with application developers to support backend data needs. Your troubleshooting skills will be essential in identifying and resolving database issues and performance bottlenecks. In order to excel in this role, you are required to possess proficiency in Oracle PL/SQL and T-SQL (SQL Server). You should have a strong knowledge of joins, subqueries, and data manipulation. Your ability to understand and work with stored procedures, functions, triggers, and scheduled jobs will be essential. Experience in reading and interpreting relational database models, understanding of indexes, constraints, and basic normalization, as well as familiarity with data profiling and basic data modeling concepts are expected qualifications. Preferred qualifications include knowledge of data migration, ETL tools, or SSIS/Oracle Data Integrator, familiarity with cloud databases such as Azure SQL or Oracle Cloud, and experience with reporting tools or writing queries for dashboards. In addition to technical skills, soft skills are also valued for this role. A strong analytical and problem-solving mindset, effective communication with business and technical teams, and self-motivation to work independently or in a team are considered essential attributes for success in this position.,