SUMMARY:

• Over 10+ years of IT experience as a Database Architect primarily focus in Database Administration, Management, Design, Modeling and Maintenance and support.Strong experience in Database design, Data analysis, development, performance tuning, monitoring and application support. Expert in installation, configuration, upgrades and database design (both physical and logical). And also experience in Amazon Web Services including migrating infrastructure to AWS cloud and maintenance of production web infrastructure.

TECHNICAL SKILLS:

OS: - Linux 8.x/7.x, AIX 7.1/5.3/4.3, Solaris, OS/400 and Windows Servers.

Languages: C, C++, JAVA, and PL/SQL, T-SQL, PYTHON.

Tools: AWS Management Console, ER/Studio, Qrep,CI/CD, Gits, scripting, Gradle, Maven, Chef, git, Ansible, Docker, Kubernetes, JENKINS, Optim, Toad, Data Studio, Export/Import, Server Manager, Quest Central, DB DIFF, Veritas Volume Manager, Command line Processor, DB2 Development Workbench, Visual Explain, Health Center, Design Adviser, Stored Procedure Builder, DPROPR, Configuration advisor, DB2 Utilities, DB2 Connect, INAV,I-Doctor,TAATOOL,MIMIX,ControlCenter,Query Patroller, Business Objects, Cognos, Crystal Reports, Erwin, BMC,, SQL*Loader,, etc.).

RDBMS: DB2 V10.1,V9.7,V9.5,EC2, V8.2 ESE, EEE and all Earlier Versions DB2/400, DB2,Oracle /9i/10g. MySQL, PostgreSQL, MongoDB, Aurora, MariaDB.

Cloud Service Platform: Amazon Web Service

Application Servers: Confidential Web Sphere and Web Logic

Web Servers: IIS, Apache HTTP Server.

PROFESSIONAL EXPERIENCE:

Confidential, Arkansas

Infrastructure engineer

Responsibilities:

• Involved on numerous customer project engagements as a subject matter expert (SME).
• Involved in reviewing and assessing current infrastructure to be migrated to the AWS cloud platform and Created new servers in AWS using EC2 instances, configured security groups and Elastic IPs for the instances.
• Involved in migrating physical Linux/Windows serversto cloud (AWS) and testing.
• Build servers usingAWS:Importing volumes, launchingEC2, RDS,creating security groups, Public and Private Subnets, Route tables,Auto-scaling,NACLs, AMI, load balancers (ELBs) in the definedVPC.
• Build and configure a virtual data center inAWScloud to support Enterprise Data warehousing.
• Maintaining the useraccounts (IAM), RDS, Route 53, SES, SQSandSNSservices.
• Worked on S3 storage services creating buckets, enabling versioning& cross region replication, using lifecycle policies to move the content toS3-IA, Glacieretc.
• Worked withLambdafunction using cloud formation templates and python scripting.
• Monitoring resources and Applications usingAWSCloud Watch, including creating notificationand alarms to monitor metrics such asEBS, EC2, ELB, RDS, S3and configured SNS notifications for the alarms generated based on events defined.
• Coordinated with developers and change management for establishing and applying appropriate branching, labeling/naming conventions using Subversion (SVN) and GIT source control.
• Implementing a Continuous Delivery framework using Jenkins, Chef, Maven& Nexus in Linux environment and also writing JENKINS jobs to automate code deployments to dev/stage/prod Environments.
• Using the Docker, deployed new running containers, worked on the setup of Docker registry and published all the Docker images to that Container registry.
• Provided On call Support 24/7 to ensure the database is performing good and also supported project related work and DR’s during the weekends for Test, UAT, Stage & Prod.

Environment: AWS-IAM, EC2, S3, EBS, Glacier, ELB, Cloud Formation, Cloud Watch, Cloud Trail, SNS, SQS, Route53,RDS, Dynamo DB, Mongo DB, Aurora, Auto Scaling, Cloud Front, Cloud Watch, Cloud Trail, VPC, Elastic Beanstalk, Elastic IP, NAT Instance, Security Groups, NACLs, Glacier, SWF,AWSCLI.), Git, Chef, Splunk, SVN, Maven, Ant, Jenkins, Apache Tomcat,Kubernetes,Docker,SonarQube,Dbvisualizer,DB2Connect,DB2v10.5.0.6,Cognos,Informatica,JENKINS,,Filenet,CURAM,Toad,Optim,DBDIFF, UNIX Bash, Shell Scripts(Ksh), SVN.

Confidential, Maryland &Missouri

Infrastructure engineer

Responsibilities:

• Installed DB2 Enterprise Server Edition V9.7 and V10.1 on AIX operating systems and also applied fixpack.
• Perform DB delta deployments in Production, Stage, UAT, and Test environment.
• Create delta scripts using DB diff tool to compare schema changes.
• Run Verification and Validation step each time for all deployments. Using shell scripts to create and grant various database accesses as required and audit user logs.
• Involvement in scripting work to automate fixes for performance related issues, proactively monitor by setting up multiple database alerts using InfoSphereOptim Performance Manager.
• Involved in running many Batch jobs with WAS admin and fixing any issue related to that job.
• Schedule Backup as required, including TSM backup. Perform Restore backup as required - from Production to lower environment.
• Gather new system requirements and storage-space availability for upcoming projects and work closely with systems and storage engineers to perform these tasks proactively.
• Responsible for documenting any infrastructure changes and operational standards.
• Test and implement new features of DB2 Enterprise Server Edition if required.
• Responsible for all the new code deployment for CURAMon Production.
• Build federated databasereportingServer.
• Responsible for installing Jenkin’s master and slave nodes and configure Jenkins builds for continuous integration and delivery.

Environment: DB2v9.7.0.3&v10.1,Cognos,Informatica,Filenet,AIX,TIVOLI, UNIX Shell Scripts (Ksh).

Confidential, Columbus

Infrastructure engineer

Responsibilities:

• Installed DB2 Enterprise Server Edition V9.7 on Linux/AIX operating systems and Data Server Client.
• Build new instances and database for new KANAproject test and Prod environments.

Environment: DB2 v9.7.0.3, HADR, OPM, Q-rep, UNIX Shell Scripts (Ksh)

Confidential, San Jose

Infrastructure engineer

Responsibilities:

• Installed DB2 Enterprise Server Edition V9.7 and V8.2 on Linux operating systems for the Upgrade project from V8.2 to V9.7 fp5
• Created best practices to follow daily, weekly, monthly to keep up the database Health.

Environment: DB2 Enterprise Server Edition V9.7 & V8.2, Quest Central, DB visualizer, DB2 Connect, QMF for Windows 8.2, UNIX Shell Scripts (Ksh),SAP

Confidential, PA

Responsibilities:

• Installed DB2 Enterprise Server Edition V9.7 on Linux and created new instances and database.
• Coordinated with vendor support to apply database patches.
• Perform daily db2 operations according to the business requirements.
• Involved in process of implementing SQL Replication.

Environment: DB2v9.7.0.3&v10.1,Cognos,Informatica,Filenet,Dbvisualizer,JENKINS,CURAM,Toad,Optim,DBDIFF, UNIX Bash,Shell Scripts(Ksh),SVN.

Confidential, FL

Responsibilities:

• Disney DB2 assets managed include production (400tb), DR (500tb), HA (500tb) and subordinate environments used for testing and staging activities.
• Diagnose and resolve database performance issues in real time.
• Coordinating performance agendas with client, scheduling implementations per systems and resource availability.
• Worked on multiple data refresh and application rollouts for new Property Management System.
• Involved with the Vision Mimix replication team and went through 7006 MIMIX Admin to perform various tasks on OS V6R1 and OS V5R4.
• Demonstrated leadership and technical competency in over 24 months on the account.