PROFESSIONAL SUMMARY:

• I have 10+ years of IT experience as Data Engineer/ DBA / AWS Solutions Architect and Software Engineer.
• I have experience with AWS and Azure, Production Servers, Servers Configuration, High Availability Groups, Replication, Log Shipping and Monitoring, Updating/ Migration of MS Server, Backup and Recovery, Query Optimization, and Security, SSIS, SSRS and SSAS packages to serve company needs.
• VPC, CloudFormation, CLI, EC2, ELB, RDS, CloudWatch, CloudFront, Route53, DynamoDB, SQS, SNS, CloudWatch Alarms and CloudTrail

TECHNICAL SKILLS:

Platforms:: Amazon Web Services (AWS), Microsoft Azure

Databases: MongoDB, RedShift, SQL Server, PostgreSQL, Lambda, EC2, S3, SSAS, SSIS

Big Data Tools: Hadoop, Spark, Kafka, SQL Server, Aurora RDS Snowflake DB

Languages: Python, HTML, CSS, JavaScript, SQL, Groovy

PROFESSIONAL EXPER IENCE:

Confidential, Rosemont, IL

Cloud DBA

Responsibilities:

• Designed backup processes for server and associated data
• Created DB accounts for all users and assign security levels
• Established a disaster recovery protocol
• Evolve and standardize AWS Organizations and IAM reference architectures, to include multiple accounts, policies, roles, federation, and data protection.
• Explored new and emerging AWS security services and technologies.
• Scheduled and perform regular DB server maintenance
• Created SQL Agent Jobs to schedule jobs for extracting data from different source systems using SSIS packages, Command Prompt
• Stored Procedures are used within these packages to aggregate the data
• Created SQL Server Traces in SQL Server Profiler, to collect a variety of information about SQL Server connections, stored procedures, and Transact - SQL statements
• Worked with both SQL and Non-SQL database and AWS
• Big Data Migration. Data warehouse strategy, data engineering, and designing data warehouses using modern technologies
• Data warehouse strategy, data engineering, and designing data warehouses using modern technologies
• Develop and enhance the HR Data Warehouse, Operational Data Store, Access DB's and systems for data performance access
• Managed the pipeline of analytics projects worked on by the team making sure targets and expectations for delivery were fulfilled
• Installed server software. Configured database servers
• Monitored and maintain system health and security

Confidential, Rosemont, IL

Cloud BDA/ AWS Cloud Engineer

Responsibilities:

• Managed AWS environments in accordance with our policies and security guidelines and assist with building and improving on those policies.
• Implemented and maintained application CI/CD using the AWS CI/CD tack
• Problem-solving skills, with the ability to see and solve issues before they snowball into problems.
• Made recommendations as needed to help the company succeed
• Assured solutions not only are a fit for the specific purpose but also closely align with the standards guidelines of technology solutions.
• Provided analysis of security protection technologies as necessary.
• Responsible for administrating, implementing and managing deployment processes for SQL Server, Aurora RDS, Snowflake DB, SSIS, DevOps, Jenkins, pipeline tool.
• Designed backup processes for server and associated data
• Evolve and standardize AWS Organizations and IAM reference architectures, to include multiple accounts, policies, roles, federation, and data protection.
• Explored new and emerging AWS security services and technologies.
• Big Data Migration. Data warehouse strategy, data engineering, and designing data warehouses using modern technologies
• Develop and enhance the HR Data Warehouse, Operational Data Store, Access DB's and systems for data performance access
• Created DB accounts for all users and assign security levels

DBA/ Senior Software Engineer

Confidential, Chicago, IL

Responsibilities:

• Monitored and maintain system health and security
• Designed backup processes for server and associated data
• Created DB accounts for all users and assign security levels
• Worked with Cloud architecture and solutions design AWS, Azure, Google
• Installed server software
• Configured database servers
• Designed solutions that deliver business value aligned with architecture principles, technology standards, best practices and guidelines.
• Served as a subject matter expert for Data architecture

Senior Software Engineer

Confidential, Seattle, WA

Responsibilities:

• Worked with various system platforms and operating systems like Windows, MAC, iOS, Android
• Worked with Manual and Automation tools Testing
• Wrote Python code
• Designed and develop large scale distributed software services and solutions
• Adhered to and drove modern software engineering practices through design reviews
• System design through well-defined interfaces across multiple components, code reviews, leveraging data / telemetry to make decisions.
• Developed “best-in-class” engineering for our services by ensuring that the services and the components are: well-defined and modularized, secure, reliable, diagnosable, actively monitored and reusable.
• Improved test coverage for services, organizes and implements integration tests, and resolves problem areas.
• Considered testability, portability/monitoring, reliability, and maintainability, and understands when his or her code is ready to be shared and delivered.
• Exposed test coverage issues, organizes and implements integration tests, and resolves problem areas.