Senior Software Engineer Resume
5.00/5 (Submit Your Rating)
SUMMARY
- Software Engineer with over 11years (17 years overall in IT) of experience in performance and capacity tuning in the finance industry, deep knowledge of algorithms and data structures, and excellent algorithmic problem - solving skills.
- Proven experience in technical (Architecture, Design) and development leadership for business solutions.
- Hands-on experience in development, design, testing, SQL / PLSQL coding, ETL pipelines design and optimization, Oracle Database performance tuning, system performance optimization, project integration and data quality.
- Experience with relational and non-relational databases, Big Data, BI reporting tools.
- Proven expertise in performance architecture, design, and development of enterprise storage with an average 20% capacity for the most important SLAs with hundreds of TB of data.
- Deep knowledge of software development methodologies SDLC, Agile (Scrum, Kanban).
- Experience in leading, departments collaboration, consulting technology projects, teaching people and coaching.
- Excellent communication and customer support skills.
- Excellent ability to analyze code and develop thoughtful, cost effective and responsive solutions, proactive capacity management.
- Willing and able to learn new problem areas, codebases, programming languages, platforms, and tools.
TECHNICAL SKILLS
RDBMS: Oracle Database 9i/10g/11g/12c.
Hardware/Server: Oracle X2/X3/X4 full rack Exadata machine.
Big Data: Oracle Big Data Appliance.
Languages: SQL,PL/SQL, Python
ETL: Informatica Power Center 8/9.5/10.2.
CDC: Vision Solution Replicate, Oracle Golden Gate, Informatica Power Exchange.
Tools: / Utilities: Quest Toad, AWR/ADDM, OEM 12c,LoadRunner, VSS, Jira.
Methodology: Agile (Scrum, Kanban), Waterfall, DevOps, CI/CD
PROFESSIONAL EXPERIENCE
Senior Software Engineer
Confidential
Responsibilities:
- Participated in the large IT team to support the company's efforts, generating ideas, and leading multiple projects in banking and financial fields.
- Coding, maintaining, supporting, and implementing DWH Core and 5 DataMart’s, Exadata, Oracle Big Data Appliance, Oracle Golden Gate 11g, Oracle BI, Tableau.
- Working on all phases of software development life cycle, maintaining the growing RDBMS size of DWH over 40 times (850+Tb), Big Data(650+Tb), number of data pipelines over 20 times (53000+ now) during 11years period. Constant performance monitoring and troubleshooting.
- Initiating and creating both short-term and long-term strategies to decrease worktime including code design, code reviews, SQL explain plans, Oracle hints, partitioning (both in Oracle DB and Informatica Power Center), compression, defragmentation, resource management.
- Performing DWH performance troubleshooting for Dev, Test, Preprod, Prod environments, successful optimization solutions, and workarounds for everyday data pipeline keeping critical SLAs 15-25% time capacity, most SLA breaching caused by non-performance problems.
- Creating ETL and PL/SQL prototypes to address business demanding data-fixes.
- Defining non-functional system requirements, establishing performance and technical targets, interacting with system architects, business analysts, and developer teams to formulate performance concepts for new versions of DWH.
- Offering a performance solution for Vision Solutions Replicate which was implemented by the vendor.