SUMMARY

• Provision online transaction database and online analytical systems using industry best practices
• Migration of databases into AWS cloud
• Building fault tolerant and highly scalable solutions for large enterprises
• Managing policies using IAM roles for S3 and EC2 instances
• Creation of non - default VPC for application servers and database servers
• Thorough understanding of AWS best solutions for fault tolerance and HA
• Proficient in using all Amazon Web services like EC2, EBS, IAM, S3, ELB, Redshift, RDS, VPC, Route 53, CloudWatch and CloudFormation, KMS etc.
• Good working knowledge of VPCs, subnets, peering between VPCs and hardware VPN configuration.
• Reduced attacks by closing off inbound/outbound routes and ports
• Identify the appropriate use of architectural best practices

TECHNICAL SKILLS

Language: SQL, PL/SQL, Shell, Batch, Python

Operating System: Solaris, AIX, RHEL, Windows

Databases: Oracle 10g,11g, 12c /SQL Server 2008 and 2012,MySQL,DynamoDB

PROFESSIONAL EXPERIENCE

AWS Cloud Architect/Engineer

Confidential, Annapolis Junction, MD

Responsibilities:

• Lead workshops for gathering requirements
• Responsible for analyzing the impact on Web Applications due to changes in the Source systems
• Responsible for documenting the code changes as per the User change requests.
• Providing added value and business continuity by writing detail environment documentation.
• Created S3 buckets and managed policies using IAM roles for S3 buckets and configured AWS Glacier to move old data to archives for storing historical data, based on the retention policy of database/applications
• Launched Amazon EC2 Cloud Instances using Amazon Web services (Linux/ Red Hat/Windows) and configured the launched instances with respect to specific applications.
• Created VPC for Application and Database servers.
• Created Cloud Formation Stack and automated with Elastic Beanstalk for the provisioning of Dev/Test/UAT/Production environment.
• Developed and maintained Cloud Formation scripts, automated the provisioning of AWS resources (IAM, EC2, S3, SNS, RDS, ELB and Auto Scaling) and installed workstations
• Migrated databases to AWS RDS Multi AZs
• Implemented and maintained the monitoring and alerting of production and corporate servers/storage using AWS Cloud watch
• Migrated .Net and Java applications data into the AWS Cloud Infrastructure

Oracle DBA/Data Analyst

Confidential, Dahlgren, VA

Responsibilities:

• Experienced with customizing PowerPlay Transformer Models to incorporate the new data elements
• Designed and developed the reports as per the requirements in Cognos
• Developed PowerPlay Cubes for better analysis of the data.
• Implemented security into Cognos Transformer Models using Macros.
• Published the Cubes to Cognos Analysis Studio using Cognos Server Admin.
• Modified existing reports and both .mdls and .iqds to incorporate the changes in the Source System.
• Prepared Test cases and solutions for Cubes and Reports validation.
• Perform Daily Validation of the cubes and reports to ensure data integrity (manual and automated)
• Troubleshot any issues with cubes and reports by investigating the underlying database objects.
• Backed up cubes by keeping the latest copy in a separate directory in case of unforeseen build process failure.
• Optimized queries for faster cube build time and maximize space.

Oracle DBA

Confidential, Bowie MD

Responsibilities:

• Performed on-going resource evaluation to assess if environment resources are suitable for the needs in Single Instance and Clustered environments (RAC)
• Leveraged Oracle technologies along with OS technologies to provide a high level of database redundancy and availability (Dataguard and Golden Gate)
• Performed routine database health checks in order to forecast possible issues
• Ensured that all aspects of database environment(s) are OFA compliant(based on the environment)
• Planned and executed of database software installations, patches (CPU) and upgrades
• Developed and executed strategies to address datafile, database sizing/storage, security, performance and optimization issues
• Oracle Enterprise Manager (dbconsole, Grid control and Cloud Control)
• SQL and Shell Scripting/Data encryption for users security
• Provided assistance in administering, monitoring, configuring, tuning, troubleshooting and correcting problems
• Database Migration/Consolidation
• Tested and Deployed in Dev, Test, and Production Environments
• Performed database schema refresh using Data Pump
• Provided added value and business continuity by writing detail environment documentation

Oracle DBA

Confidential, Frederick MD

Responsibilities:

• Installed the oracle database server software using industry best practices
• Performed routine health checks
• Performance information and monitoring/interpreting alert log and trace files.
• Schema object management
• Allocated system storage and capacity planning.
• Applied patches and upgrading databases
• Planned and implemented backups/recovery strategies using RMAN and Logical Backups
• Developed and maintained shell scripts to monitor the database
• Managed users, Privileges and Roles
• Understanding of Oracle architecture and database infrastructure
• Installation, database creation and configuration
• Data integrity and security
• Performance Tuning
• Creation of database objects