Dynamic Database Engineer devoted to maintaining reliable computer systems for uninterrupted workflows. Delivers up-to-date methods to increase database stability and lower likelihood of security breaches and data corruption. Offers detailed training and reference materials to teach best practices for system navigation and minor troubleshooting.
Experience in Design and development of data pipelines by ingesting various feeds from different external data sources
(D&B, Equifax and Infogroup) and preform data cleansing, transform, and process the data and store the results in near
real-time to perform exploratory analysis and discover data acquisition opportunities.
✦ Experience in using Amazon Web Services (Amazon EC2, Amazon S3, Amazon RDS, Amazon Elastic Load Balancing,
Amazon SQS, AWS Identity, and access management, Amazon SNS, AWS Cloud Watch, Amazon EBS, Amazon
CloudFront, VPC, DynamoDB, Lambda, and Redshift).
✦ Hands on experience in various Big Data application phases like Data Ingestion, Data Analytics & data visualization. ✦
Experience in developing complex user defined functions (UDF) using Java to handle nested JSON data. ✦ Develop Hive
scripts to create External and Internal table schemas in Hive to handle static and dynamic partitions to improve efficiency.
✦ Experience in developing Oozie workflows with dependencies and automate the data pipelines using Oozie Coordinator.
✦ Creating and enhancing CI/CD pipeline to build, test, and deploy using Jenkins and UCD.
✦ Hands-on knowledge in designing Database schema by achieving normalization.
✦ Hands-on technical expertise in JAVA, Scala & SQL with primary exposure to financial domain. ✦ Experience in
handling various file formats which include CSV, txt, dat, ORC, AVRO and Parquet file formats. ✦ Experience in handling
production jobs, perform initial triage, identify immediate and permanent fix based on the root cause analysis for all the
production defects and provide hot fixes.
✦ Strong expertise in Java, Core Java concepts like Collections, Multithreading, Generics, Exception Handling and Java
Beans. Experience with RDBMS concepts and in writing Queries, Functions, Triggers, Stored Procedures, Cursors and
PL/SQL Packages with databases like Oracle 10/11g, MySQL.
✦ Good Knowledge in building and deploying Apache ANT/MAVEN scripts for deployment and customizing
WAR/JAR/EAR file management for web applications.
✦ Working knowledge on Kubernetes to deploy scale, load balance, and manage Docker containers. ✦ Proficient in all
phases of Software Development Life Cycle (SDLC), including Requirements gathering, Analysis, Design, Reviews,
Coding, Unit Testing, and Integration Testing.
✦ Analyzed the requirements and developed Use Cases, UML Diagrams, Class Diagrams, Sequence, and State Machine
Diagrams.
✦ Well versed with Scrum methodologies.
✦ Excellent communication and interpersonal skills with the ability to resolve complex business problems.
✦ Direct interaction with client and business users across different locations for critical issues.