To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed are representative of the knowledge, skill, and / or ability required.
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Deep hands-on technical experience with the following technologies :
Relational databases mainly Oracle, Postgres. This includes knowledge of tools used for running queries, performing DB schema changes and analyzing database activity / performance.
Writing advanced SQL, analyzing developer SQL and make recommendations for performance tuning SQL, rewriting SQL or adding indexes for efficiency and creating / updating stored procedures.
PL / SQL coding, creating stored procedures, triggers, functions, packages, Logical and Physical database design.
ETL tool experience with Datastage and Symmetric DS
Proficient in the following technologies :
Oracle 11g / 12c and Postgres databases, and other NoSQL DB.
Design and developing stored procedures
Unix / Linux
Good to have technologies :
Exposure to any cloud platform
Education and / or Experience :
Bachelor's degree in Computer Science or related technical discipline; or equivalent practical experience with strong competencies in SQL and database design.
Experience developing underlying data models and databases (Oracle, and Postgres).
Experience maintaining and managing all versions of data models for production, testing and developing databases.
Experience developing, managing and maintaining data dictionary and or metadata.
Experience ensuring compliance of standards and conventions in developing programs.
Experience designing, developing and implementing complete development life cycle
Experience responding to user requests for data and reports.
Exceptional customer relationship skills including the ability to discover the true requirements underlying feature requests, recommend alternative technical and business approaches, work with architects to come to an agreed technical approach, and lead development efforts to meet aggressive timelines with optimal solutions.
Ability to work collaboratively with or lead cross-functional teams with minimal supervision.
Ability to drive consensus within a team and influence outcomes in significant technical decision-making.
Excellent interpersonal, written and verbal communication skills to work with different business groups as well as IT partners (data and enterprise architects, vendors, etc.)
Extreme attention to detail and organization in all aspects of the system development.
Resolve and troubleshoot complex issues as required to ensure the availability and performance of developed ETL solutions, reports and dashboards for both external and internal users.
Ability to effectively plan, organize and prioritize multiple streams of activity. Adapt well to changes.
Demonstrated ability to meet commitments and multi-task in a fast-paced work environment with a high-level of accuracy and efficiency.
Demonstrated critical thinking skills.
Open-minded, willing to consider multiple options, sources, perspectives, and possible solutions. Careful assessment of the importance, relevance, and validity of all options.