Home

STANISLAUS BRITTO - Sr Database Engineer/AWS Solution Architect

[email protected]

Location: Atlanta, Georgia, USA

Relocation: current project is going to be end

Visa: H1b

STANISLAUS BRITTO AWS Senior Database Consultant [email protected] 813-319-4244 PROFESSIONAL EXPERIENCE: 20 Years of experience in IT industry in various roles as AWS Architect, Database Migration Specialist, AWS Cloud Engineer, Senior Database Consultant and Senior Database Administrator. Experience with migrating mission critical database environments from on premise to AWS Cloud. Dedicated and highly skilled AWS Cloud Engineer with expertise in designing, developing, and managing serverless applications, data integration, and database solutions using AWS services such as AWS Step Functions, AWS Lambda, AWS Event Bridge, Amazon Aurora PostgreSQL, AWS Glue, and AWS Database Migration Service (DMS). Experience with using a broad range of AWS technologies (e.g.EC2, RDS, Aurora, DMS, SSM, SNS, SQS, SES, IAM, KMS, VPC, Auto Scaling, S3, Glacier, DynamoDB, Kinesis, Redshift, EMR, Route53, CI/CD Pipeline, Athena, Glue, Network related services, Lambda, monitoring services, CloudFormation, Data Pipeline, Step Functions etc.) to develop and maintain an AWS based cloud solution, with an emphasis on best practice cloud security. Expertise in database architecture, performance tuning, data migration, disaster recovery, and security. Experience in AWS Security Services such as AWS Cloud HSM, Guard Duty, Amazon Inspector, AWS Key Management Service, Amazon Macie, AWS Shield, and Security Groups for access control of network subnets, VPC s and AWS resources. Actively worked on cost optimization strategies for cloud configuration which resulted over reduction of AWS costs by 50%. Good knowledge and experience of monitoring, logging and cost management tools that integrate with AWS. Experience in Automated Infrastructure as Code with CI/CD Pipelines and AWS CloudFormation. Ability to identity and gather requirement to define a solution to be built and operate on AWS. Good experience in creating and editing Shell, Bash, Python Scripts for automation. Extensive experienced in all database architecture, data migrations, disaster recovery, production support, Performance tuning, troubleshooting, capacity planning, Installation, configuration, Database upgrades/migrations and hotfixes. Experience in providing production support (24x7) and provide resolution of L1, L2 tickets within SLA. Provide support during off business hours for regular maintenance activities. Adept at collaborating with cross-functional teams to deliver innovative and scalable database solutions that meet business objectives. CERTIFICATION & TRAINING AWS Certified Database Specialty AWS Certified Solutions Architect Associate AWS for Architects: Advanced Security AWS for Architects: Network and Storage Design AWS for Developers: RDS MySQL Database with Lambdas AWS for Developers: SNS, SQS, and SWF AWS Migration Solutions Architect Advanced SQL for Query Tuning and Performance Optimization Certified - Microsoft Certified MS SQL -Database Administration Certified - IBM Certified DB2 UDB Database Administration Hands-on Training & Certification on Hadoop Ecosystem (2016) Received Certificate on excellence is presented to 2016,2017 Disaster Recovery Exercise (BCBS) Qualifications Master of Computer Applications (MCA) -Bharathidasan University, India Technical SKILLS Database Architecture and Design Cloud Infrastructure Design AWS RDS, Aurora, DynamoDB, Redshift Performance Tuning and Optimization Data Migration and Replication Disaster Recovery Planning Security and Compliance Cost Optimization Serverless Architecture SQL and NoSQL Databases DevOps and CI/CD Automation and Scripting Leadership and Mentoring Communication and Collaboration Scalability and availability solutions EMPLOYEMENT HISTORY Amzur Technologies Oct 2013 Till Date Cloud Engineer AWS Database Services, Sr Database Administrator Tata Consultancy Services Apr 2004 - Oct 2013 Associate Consultant NIIT Technologies Jun 2003 - Apr 2004 System Analysist WORKING EXPERIENCE Current Assignment Customer & Location Project Role Project Duration Gartner Inc, Irving TX Senior Database Migration Consultant Apr 2022 Present Executed successful database migration projects using AWS Database Migration Service (DMS), Including homogeneous and heterogeneous migrations, minimizing downtime and ensuring data consistency. Designed and implemented serverless workflows using AWS Step Functions to orchestrate microservices and automate business processes, resulting in improved efficiency and reduced operational overhead. Configured Glue ETL framework, DMS for data replication between different databases. Design and implementation of high-performance database architecture for mission-critical applications on AWS, resulting in a 30% improvement in query response times. Designed and implemented infrastructure as code using Jenkins, and Terraform, improving deployment consistency and infrastructure scalability. Worked on architectural design reviews and provided recommendations for optimizing performance, cost, and security of AWS solutions. Collaborated with clients to gather requirements, formulate solutions architectures, and present technical proposals tailored to their needs. Designed and implemented highly available and fault-tolerant database solutions and ensuring 99.99% uptime for critical applications. Developed disaster recovery strategies and conducted regular failover testing, ensuring data integrity, and minimizing downtime during unforeseen events. Configured Datadog, CloudWatch metrices to monitor all AWS resources including creating alarms. Conducted regular performance assessments, identifying, and resolving bottlenecks, and optimizing database configurations to enhance applications responsiveness. Developed and delivered technical training sessions for internal teams and clients, improving their understanding of AWS database services and best practices. Environment: AWS Cloud Services, Azure SQL Server, Oracle, PostgreSQL, DynamoDB, Glue, Linux, Windows, Python, JIRA, TFS, Service Now Previous Assignments Customer & Location Project Role Project Duration Thomson Reuters, Eagan MN AWS Solutions Architect & AWS Database Migration Consultant Nov 2019 Apr 2022 Migrate databases (Oracle, PostgreSQL, MS SQL server) from on premise to AWS Cloud. Configured and managed the High-Availability and Disaster recovery (HADR) to make the environment up and running in case of any unexpected disaster. Created runbook for Database failover to DR region and configured automated scripts for Database failover to DR region with just few clicks. Automated Infrastructure as Code with CI/CD Pipelines and AWS CloudFormation. Configured Datadog, CloudWatch metrics to monitor all the AWS resources including creating alarms to monitor metrics such as EBS, EC2, ELB, DMS, RDS, Aurora, DynamoDB, S3, SNS and configured notifications for the alarms generated based on events defined. Worked on cost optimization project which resulted over reduction of AWS costs by more than $1million. Configured and managed multiple levels of security for databases which includes network isolation using Amazon VPC, encryption at rest using AWS KMS and encryption of data in transit using SSL. Written various Lambda functions for automating the functionality on the Cloud. Implemented MSSQL 2016 on EC2 with Type 2 (High-Availability Deployment) and Type 3 (High Availability + Disaster Recovery Deployment) model. Implemented MSSQL 2019 on EC2 with SIOS Data keeper for HA/HA+DR. Install patches on a regular basis by using AWS SSM Patch Manager. Created tagging standards for proper identification and ownership of EC2 instances and other AWS resources. Configured S3 cross account access to objects that are in Amazon S3 buckets. Creating/Managing DNS records on Amazon Route 53. Configured and deployed AWS Cloud Automation using Python & Boto3 Scripts. Creating/Managing AMI/Snapshots/Volumes, Upgrade/downgrade AWS resources. Worked on JIRA for defect/issues logging & tracking and documented all my work using CONFLUENCE. Worked on loading and transforming large sets of structured, semi structured, and unstructured data. Environment: AWS Cloud Services, MSSQL Server, Oracle, PostgreSQL, Linux, Windows, Python, JIRA, TFS, Service Now Customer & Location Project Role Project Duration Blue Cross Blue Shield of Minnesota, Eagan, MN AWS Solutions Architect & Sr. Database Administrator Feb 2015 Oct 2019 Work with application and architecture teams to conduct proof of concept (POC) and implement the design in production environment in AWS. Manage the AWS infrastructure and work with internal teams to create the migration process of legacy systems to the AWS cloud. Work with Security division to design and manage IAM roles for users. Design, build and run database infrastructure at scale both on-premises and with cloud providers. Working on RDBMS database migrations to Amazon RDS (Aurora MySQL/PostgreSQL) Operating integration/test environment in cloud, run and analyze test results, perform diagnostics and troubleshooting, open, prioritize, and help triage defects, track and report test status and results. Supporting the entire customer migration life cycle from strategic planning to tactical execution. Contribute your ideas on improving the operational and strategic health of the environment. Proactive performance monitoring. Mentor application developers to optimize processes and ensure efficient use of shared infrastructure. CloudFormation - Managing AWS Infrastructure as code. Used CloudWatch logs to monitor all the AWS resources and create alarms based a few exceptions raised by application. Developing python scripts for automating tasks. Worked on loading and transforming large sets of structured, semi structured, and unstructured data. Developed scripts to Extract, Load and Transform data (Glue) Extracted data from DynamoDB thru Lambda function and stored into S3 as CSV file format. Managing DB2 LUW, MS Server, PostgreSQL, MYSQL databases. Setting up HADR across all the environments. Providing 24x7 on call Support for production environment. Environment: AWS Cloud Services, DB2 LUW, MS SQL Server, AIX, Windows, MYSQL, PostgreSQL, JIRA, Service Now. Customer & Location Project Role Project Duration First Data, Omaha, NE Sr. Database Administrator May 2014 Feb 2015 John Deere -Moline Illinois Sr. Database Administrator Oct 2013-May 2014 Responsibilities Worked on Sybase migration project. Migrating from Sybase ASE 12.5.4 to SQL Server 2012 Enterprise Edition. Responsible for installation, configuration, and maintenance of MS SQL Server on various environments. Configure and troubleshooting high availability scenarios involving Clustering, Database Mirroring, Log Shipping and Replication. Monitor availability and performance of production databases and servers. Migrated SQL Server 2008 to SQL Server 2012 in Windows server 2012 Enterprise Edition. Responsible for installation, configuration, and maintenance of Microsoft SQL Server (Versions 2008 R2 and 2012) on various environments. Responsible for monitoring and making recommendations for performance improvement in hosted databases. To analyze long running slow queries and tune the same to optimize application and system performance. Provide after hours on-call support for critical database issues. Environment: AWS Cloud Services, DB2 LUW, MS SQL Server, AIX, Windows Assignments Customer & Location Project Role Project Duration DTCC, Tampa, FL Sr. Database Administrator (Team Lead) Feb 2009 Oct 2013 Target, Minneapolis, MN Sr. Database Administrator Feb 2006-Jan 2009 Amex, Phoenix, AZ Database Administrator Apr 2004-Jan 2006 Responsibilities DB2 UDB / SQL Server / Oracle/ Sybase ASE database administration. Involved database upgrades. Monitor availability and performance of production databases and servers. To analyze long running slow queries and tune the same to optimize application and system performance. Participated in the design, development, review, documentation, and implementation of data models for database with special emphasis towards assuring data integrity and database performance. Experienced in Setup and monitored database replication. Extensive experience of developing shell scripting for database maintenance. Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions. Release planning and database change management Implementation & Maintenance of development, QA, and Production environments. Database problem identification, resolution, and root cause analysis. Implementing database DDL changes. Monitor database growth, index fragmentation, and minimize I/O bottlenecks. Performance monitoring: - Monitoring memory, CPU utilization, disk utilization, locks, deadlocks, runtime of queries. Created database, users, table spaces, tables, views, stored procedures, functions, and grants in development, testing environment and deployed to production & DR environments. Maintaining the overall project plans. Co-ordinate with onsite team for Technical / Business Clarification. Providing 24x7 on call Support Environment: DB2 UDB, Oracle, Sybase, MS SQL, AIX, Windows. ING-Repetitive Payment System ING | Application DBA | Jun 2003 April 2004 Managed database recovery by performing & point-in-time restores, table space restores in case of crash, application malfunction and table space load pending states. Database analysis, design, development, testing and implementation. Database objects creation & alteration (objects like Tables, Indexes, Stored procedures, Views, Triggers, Rules, Defaults, user defined data types and functions) Database Backup / Recovery on databases and file system backups. Developing SQL scripts for maintaining administration tasks. Environment: DB2 UDB, AIX Keywords: continuous integration continuous deployment quality analyst sthree information technology microsoft Arizona Colorado Florida Minnesota Nebraska Texas