Data Migration Database Developer
Resume:
Steve Sam
AWS/Oracle Lead Engineer
**********@*****.*** • 508-***-****
LinkedIn • Tampa, FL
Tech-savvy professional with a proven ability to architect and enhance database solutions on AWS and Oracle platforms to ensure optimal performance and scalability to meet dynamic business needs. Skilled in designing, implementing, and maintaining complex database systems, specializing in AWS and Oracle environments. Expert at optimizing data integrity and performance through meticulous database architecture and system tuning. Proficient in leading cross-functional teams to execute projects from concept through delivery. Experienced in integrating database management with cloud technologies and applying best practices in security and data migration. Adept at troubleshooting and resolving complex database issues to reduce downtime and improve user satisfaction. Accomplished in developing and overseeing large-scale data structures and backend solutions for real-time applications. Committed to continuous learning and adoption of emerging technologies to drive innovation and technical advancements. Areas of Expertise
Oracle Database Management
Database Scalability Solutions
AWS Solution Architecture
Data Analysis
Cross-Functional Team Leadership
System Performance Optimization
Security Compliance Standards
Technical Project Management
Strategic System Upgrades
Data Integrity Assurance
Advanced Query Tuning
Cloud Data Migration
Technical Proficiencies
AWS Technologies: Redshift, RDS, EC2, S3, IAM, SNS, SQS, Lambda Oracle Technologies: Oracle Database 9i/11g/12c, SQL, Forms 6i, Reports 6i Other Databases:
Programming Languages:
SQL Server, DB2, Sybase and Teradata
PL/SQL,SQL,Python
ETL: Talend, SSIS
Workflow Orchestration:
CICD/Version Control
Apache Airflow, Eventsys
Gitlab, Jenkins, Bitbucket
Professional Experience
Nielsen, Oldsmar 2017 – Present
Senior Software Engineer
Lead, design, develop, and maintain software applications by ensuring high performance and scalability for end users. Collaborate with cross-functional teams, including product managers and designers to gather requirements and define software features. Lead code reviews and provide mentorship to junior engineers by promoting best practices and coding standards. Troubleshoot, debug, and resolve complex software issues by improving reliability and user experience.
● Designed and led the data migration project including moving the data from Oracle and Netezza to AWS Redshift, AWS RDS, and the ETL processes from ODI to Talend and Airflow.
● Increased revenue by optimizing Redshift processes, reducing data delivery lag from four to three days through parallel processing and strategic use of query priority, distribution keys, and sort keys.
● Took steps to closely monitor very large tables and long-running queries periodically and come up with suitable custom solutions to optimize the process without impacting the delivery to the client.
● Successfully implemented measures to decrease the storage cost by AWS S3 by creating life cycle policies.
● Enhanced team productivity at Nielsen by implementing a customized monitoring/alerting tool, eliminating weekend shifts, and reclaiming sixteen man-hours per week.
Environment:AWSRedshift,RDS,S3,IAM,EC2,Lambda,SQS,SNS,SFTP,Terraform,SQL,Talend,Airflow,Python,Netezza,Oracle,ODI, DBVisualizer, JIRA, Gitlab, Bitbucket, Grafana, Jenkins Page 2 3
Cognizant Technology Solutions US Corp, United States 2013 – 2017 Associate–Projects
Managed planning, execution, and monitoring of projects by ensuring alignment with timelines, budget, and quality standards. Assisted project managers in gathering and analyzing project requirements by creating detailed project plans and coordinating resources. Tracked project progress, identified potential risks, and provided updates to stakeholders by helping to maintain clear communication across teams. Prepared project documentation, including status reports, meeting minutes, and process maps.
● Boosted team productivity by automating test data generation and writing scripts that significantly reduced preparation time for unit testing.
● Took steps to closely monitor very large tables and long-running queries in Oracle and used effective strategies to optimize the performance by tuning those SQLs without impacting the delivery to the client.
● Optimized database performance by refactoring complex SQL queries and implemented indexes, resulting in an improvement in report generation speed.
● Increased data model efficiency by implementing scalable data architecture to increase system response times. Environment: Oracle, PL/SQL, SQL, Java, Jenkins, Unix, SQL Developer, TOAD Cognizant Technology Solutions, Chennai, India 2011 – 2013 Associate–Projects
Designed, developed, and delivered application enhancements, and several generic components primarily on Oracle PL/SQL and Unix, as stored procedures, packages, or standalone scripts. Designed and reviewed data models pertaining to the requirements outlined. Compiled the most optimum and feasible design in terms of performance and maintenance, after thorough analysis of the requirement. Gathered business process requirements, high level business model design, business process re-engineering.
● Identified long-running queries and rewrote them to enhance the performance after analyzing the explain plans resulting in lesser overall processing time.
● Optimized indexing strategies, reduced data retrieval time, and improved query performance by use of bulk collections. Environment: Oracle, PL/SQL, SQL, Unix, SQL Developer, TOAD Dell International Services, Bangalore 2010 – 2011 Software Development Analyst
Designed and analyzed various approaches for maintaining different dimensions and facts in the process of building data warehouse applications. Designed, developed, and deployed ETL packages in Microsoft SQL Server environment using SSIS in Business Intelligence Development Studio. Used SSIS transformations such as Aggregate, Derived Column, Data Conversion, SQL task, Script task and Send Mail. Created OLAP cubes for data mining and reports from those OLAP cubes using SSRS.
● Performed T-SQL tuning, multi-tasking and optimizing queries which took longer to get executed in SQL Server 2005/2008
● Achieved reduction in ETL processing time by optimizing SQL Server SSIS packages and improving data integration speed. Environment: SQL Server, SSIS, SSAS, SSRS, SQL Server Management Studio Cognizant Technology Solutions, Chennai 2010
Programmer Analyst
Spearheaded, designed, maintained databases, optimized queries, and ensured data integrity for seamless application performance. Provided technical support and troubleshooting for software issues by resolving incidents to minimize downtime and ensure user satisfaction. Stayed updated with latest programming languages, frameworks, and industry trends to recommend improvements and maintained competitive edge in software solutions.
● Took initiatives to help the QA team by providing them training on basic SQL to help them test the application effectively.
● Enhanced system stability and reduced downtime by producing problem resolution and continuous enhancements. Environment: Oracle, PL/SQL, SQL,Unix,SQL Developer,TOAD Page 3 3
3i-Infotech, Chennai 2007-2010
Software Engineer
Developed and customized new and existing features to an Insurance product which takes care of the end-to-end Insurance processes right from Underwriting to Claims. Written Stored Procedures using PL/SQL and functions and procedure for common utilities. Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors, and packages. Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
● Streamlined troubleshooting and reduced issue resolution time by implementing detailed documentation processes.
● Improved application performance through SQL query optimization and significantly enhanced user experience. Environment: Oracle,Oracle Forms,Oracle Reports,PL/SQL, SQL,Unix,SQL Developer,TOAD Additional Experience
IT Recruitment Assistant Manager, Covenant Consultants, Chennai 2005 – 2007 Education
Bachelor of Engineering 2000 – 2004
Rajarajeswari Engineering College, University of Madras, Chennai, India
Contact this candidate