Data Base Tech Lead

Job Title & Location

Data Base Tech Lead

Relevant Experience

(in Yrs)

6-10 Years

Technical/Functional Skills

AWS Python, Postgres, Oracle, ETL, PLSQL Packages & Procedures

Experience Required

6-10 Years

Roles & Responsibilities

Responsibilities:

- Analyze business requirements, propose, design and implement technical solutions

- Responsible for design and development of data architecture and ETL dataflows in support of enterprise risk management, analytics and reporting

- Work effectively with the DBA teams to ensure that all approved development and deployment procedures are followed.

- Provide production support from development teams for existing systems, troubleshoot data and/or system issues

- Identify root causes and resolve data related issues

- Review and optimize query performance

Required Qualifications:

- Extensive experience with database development tools (Oracle, Toad), ETL and integration technologies

- Experience developing large scale systems

- Experience developing interfaces to Oracle or other SQL-based databases

- Experience working in controlled development, testing and production environments

- Experience in Data Modeling, Data Warehousing, PL/SQL, ETL processing

- Familiarity with development toolkits & source repositories SVN/GIT etc.

- Sound understanding of RDBMS

- Strong written and oral communication skills

- Excellent problem-solving and quantitative skills

- Aptitude for debugging problems in complex, unfamiliar code

- Demonstrated ability to work as part of a team

- Solid work ethic, self-driven with the ability to work with minimal supervision

• Implement and maintain the database design
• Create database objects (tables, indexes, etc.)
• Write database PLSQL Packages, procedures, functions and triggers
• Assist team members (Developers/QA/DevOps) with dat abase activities
• Tune database queries
• Monitor application related jobs and data replication activities