Computer science graduate with a versatile experience in backend development on different stacks. Sound expertise in AWS, databases, Business Intelligence. My career goal is to assume a role in the company where I can utilize my extensive experience and further grow by learning new skills.
• Database developments (SQL Server, Redshift, MySQL Aurora)
• Amazon Web Services with deep expertise in Amazon Redshift, ETL using Data Pipelines, Database Migration Services(DMS), State machines, Lambda, IAM, SNS, s3, Cloud watch, Scheduling, SES, Glacier, Athena, EC2, AWS Transfer for SFTP, Linux Worker Group implementation with crontab
• Lifecycle Transition policies
• Responsible for creating/managing database, database objects, users, roles
• Data optimization
• Daily monitoring/troubleshooting of ETL process
• Assistant to QA team for testing of different complex scenarios
• Good hands on experience in implementing Data Ware Housing Star & Snow flake schema Structure
• Responsible for Sort Key & Distribution Key strategies and optimizations in Amazon Redshift
• Responsible for creating database, database objects, users, roles.
• Developed stored procedures to optimize statistics collection process on Production databases.
• Automation of Data ETL
• Designed and implemented stored procedures views and other application database code objects.
• Maintained SQL scripts indexes and complex queries for analysis and extraction.
• Performed quality testing and assurance for SQL servers.
• Deployment of SSIS packages with ETL & Reporting Services
• Worked in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, E-R Diagrams.
• Bug fixing, Deadlock handling in SQL with performance improvements
• Analyzing & Reviewing current system
• Maintaining the stability of all live systems
• Analyzing Client requirements