Sr. Developer, AVP

Barclays•Jefferson, CO

12d•$189,592 - $195,000•Hybrid

About The Position

The purpose of the role is to design, develop, and improve software using various engineering methodologies, providing business, platform, and technology capabilities for customers and colleagues. This involves developing and delivering high-quality software solutions using industry-aligned programming languages, frameworks, and tools, ensuring code is scalable, maintainable, and optimized for performance. The role requires cross-functional collaboration with product managers, designers, and other engineers to define software requirements, devise solution strategies, and ensure seamless integration with business objectives. Collaboration with peers, participation in code reviews, and promotion of a culture of code quality and knowledge sharing are essential. Staying informed of industry technology trends and innovations and actively contributing to the organization’s technology communities to foster technical excellence and growth is also a key aspect. Adherence to secure coding practices to mitigate vulnerabilities, protect sensitive data, and ensure secure software solutions, along with the implementation of effective unit testing practices for proper code design, readability, and reliability, are critical.

Requirements

Design, develop and maintain Oracle database applications using SQL, PL/SQL, advance features like In memory, Container and Pluggable databases, and other database programming languages.
Research and analyze Enterprise Voluminous Data and perform efficient data management using Artificial Intelligence and Machine Learning techniques and Algorithms.
Implement and maintain tight access control using security features like Virtual Private database (VPD), Redaction, etc.
Design, maintain and publish data models for Star (Dimensional) and Snowflake (Normalized) using tools like ERwin, TOAD or ER Studio.
Design and implement efficient database programs through bulk data handling using PL/SQL Tables, Nested Tables, and Arrays in Oracle, Databricks, Snowflake, and Cloud Data Warehouses.
Manage and process high data volumes, including Petabytes and Exabytes, to meet on premises and cloud onboarding requirements.
Optimize database performance using various partitioning methods, materialized views, inline views, and temporary tables.
Conduct performance tuning by query optimization, tuning memory, and tuning disk usage with tools such as Explain Plan, RTSM, AWR, Hang Analyzer, ASH, and ADDM reports.
Facilitate Scrum sessions with clients, customers, vendors, SMEs, and other stakeholders for reporting and multiple functional and business requirements.
Automate tasks using Python, Shell scripts, Perl scripts, and PL/SQL.
Provide support during System Integration Testing (SIT), User Acceptance Testing (UAT) and Production deployment including root cause analysis, issue resolutions and closures.
Design and develop database schemas, stored procedures, queries, views, and fine-tune databases covering Cloud and Non cloud data warehouses for creating business critical reports and data products.
Develop and implement designs for data warehouse and related ETL processes utilizing Oracle Big Data SQL to fetch data from HDFS (Hadoop file systems), Object Store, Parquet, Avro, and Apache Spark.
Perform Proof Of Concepts (POC) using Big data technologies like Hive, Impala, Spark, HDFS, etc.
Evaluate cloud databases like Databricks, Snowflake, and Starburst on different platforms like AWS, Azure and Google.
Track defects and maintain code version using various software tools used for code repository, defect tracking, version control like GitLab, GitHub, SVN, and ClearCase.

Nice To Haves

May telecommute pursuant to company policies.

Responsibilities

Development and delivery of high-quality software solutions by using industry aligned programming languages, frameworks, and tools.
Ensuring that code is scalable, maintainable, and optimized for performance.
Cross-functional collaboration with product managers, designers, and other engineers to define software requirements, devise solution strategies, and ensure seamless integration and alignment with business objectives.
Collaboration with peers, participate in code reviews, and promote a culture of code quality and knowledge sharing.
Stay informed of industry technology trends and innovations and actively contribute to the organization’s technology communities to foster a culture of technical excellence and growth.
Adherence to secure coding practices to mitigate vulnerabilities, protect sensitive data, and ensure secure software solutions.
Implementation of effective unit testing practices to ensure proper code design, readability, and reliability.
Advise and influence decision making, contribute to policy development and take responsibility for operational effectiveness.
Collaborate closely with other functions/ business divisions.
Lead a team performing complex tasks, using well developed professional knowledge and skills to deliver on work that impacts the whole business function.
Set objectives and coach employees in pursuit of those objectives, appraisal of performance relative to objectives and determination of reward outcomes.
Lead collaborative assignments and guide team members through structured assignments, identify the need for the inclusion of other areas of specialisation to complete assignments.
Identify new directions for assignments and/ or projects, identifying a combination of cross functional methodologies or practices to meet required outcomes.
Consult on complex issues; providing advice to People Leaders to support the resolution of escalated issues.
Identify ways to mitigate risk and developing new policies/procedures in support of the control and governance agenda.
Take ownership for managing risk and strengthening controls in relation to the work done.
Perform work that is closely related to that of other areas, which requires understanding of how areas coordinate and contribute to the achievement of the objectives of the organisation sub-function.
Collaborate with other areas of work, for business aligned support areas to keep up to speed with business activity and the business strategy.
Engage in complex analysis of data from multiple sources of information, internal and external sources such as procedures and practises (in other areas, teams, companies, etc).to solve problems creatively and effectively.
Communicate complex information.
Influence or convince stakeholders to achieve outcomes.
Design, develop and maintain Oracle database applications using SQL, PL/SQL, advance features like In memory, Container and Pluggable databases, and other database programming languages.
Research and analyze Enterprise Voluminous Data and perform efficient data management using Artificial Intelligence and Machine Learning techniques and Algorithms.
Implement and maintain tight access control using security features like Virtual Private database (VPD), Redaction, etc.
Design, maintain and publish data models for Star (Dimensional) and Snowflake (Normalized) using tools like ERwin, TOAD or ER Studio.
Design and implement efficient database programs through bulk data handling using PL/SQL Tables, Nested Tables, and Arrays in Oracle, Databricks, Snowflake, and Cloud Data Warehouses.
Manage and process high data volumes, including Petabytes and Exabytes, to meet on premises and cloud onboarding requirements.
Optimize database performance using various partitioning methods, materialized views, inline views, and temporary tables.
Conduct performance tuning by query optimization, tuning memory, and tuning disk usage with tools such as Explain Plan, RTSM, AWR, Hang Analyzer, ASH, and ADDM reports.
Facilitate Scrum sessions with clients, customers, vendors, SMEs, and other stakeholders for reporting and multiple functional and business requirements.
Automate tasks using Python, Shell scripts, Perl scripts, and PL/SQL.
Provide support during System Integration Testing (SIT), User Acceptance Testing (UAT) and Production deployment including root cause analysis, issue resolutions and closures.
Design and develop database schemas, stored procedures, queries, views, and fine-tune databases covering Cloud and Non cloud data warehouses for creating business critical reports and data products.
Develop and implement designs for data warehouse and related ETL processes utilizing Oracle Big Data SQL to fetch data from HDFS (Hadoop file systems), Object Store, Parquet, Avro, and Apache Spark.
Perform Proof Of Concepts (POC) using Big data technologies like Hive, Impala, Spark, HDFS, etc.
Evaluate cloud databases like Databricks, Snowflake, and Starburst on different platforms like AWS, Azure and Google.
Track defects and maintain code version using various software tools used for code repository, defect tracking, version control like GitLab, GitHub, SVN, and ClearCase.