SUMMARY

• Over 7+ years of IT experience (in Cloud since 2012) AWS Cloud Solutions, Identifying and Selecting teh AWS Cloud Services, Architecting teh Services in Cloud Infrastructure such IAAS, PAAS and SAAS. Database Architecture, Administration, System Analysis, Design, Development and Support of MS SQL Server
• Expert - level noledge of Amazon EC2, Amazon S3, Amazon SimpleDB, Amazon RDS, Amazon Elastic Load Balancing, Amazon SWF, Amazon SQS, and other services of teh AWS infrastructure.
• Designing a cloud solution for migrating large scale web platform toAWS cloud.
• ConfiguredAWSIAM and Storage Group Security in Public and Private Subnets in VPC.
• Architected, Designed and Developed teh Backup and Archiving, Disaster Recovery in AWS Cloud.
• Fundamental mastery of teh AWS cloud computing platform, and its many dimensions of scalability - including but not limited to: VPC (Virtual Private Cloud), EC2, load-balancing wif ELB, messaging wif SQS (and scalable now-AWS alternatives), autoscaling architectures, using EBS under high me/O requirements, custom monitoring metrics/analysis/alarms via CloudWatch.
• Demonstrate teh capacity to deploy complex infrastructure using CloudFormation.
• Demonstrate experience in creating complex IAM policies for delegated administration wifin AWS.
• Experience in Installation,Configuration,Upgrades,migrations,HighAvailability,SecurityAdministration, Database Development and data modeling across various Clustered/Stand-Alone Database environments
• Hands-On Experience in writing & debugging Stored Procedures, Complex queries, Triggers, functions and Troubleshooting code Issues in Confidential -SQL.
• Migration experience using both In place & Side-by-side from SQL 2000à2005à2008 R2 using Upgrade Wizard and Upgrade Advisor in both Clustered and Non Clustered Environments.
• Experience in migration of Databases from SQL Server 2000/2005 to SQL Server 2008 R2 and troubleshooting migration issues on both 32-bit and 64-bit Environments.
• Expert in Data Extraction, Transforming and Loading (ETL) from Heterogeneous sources like Excel, MS Access, XML, Oracle, DB2 to MS SQL Server using SQL Server Integration Services (SSIS), DTS, Bulk Insert, and BCP.
• Creating and maintaining DTS/SSIS Packages /Jobs for huge data transfers and various ETL activities.
• Installation, Configuration & Administration of SSRS 2000/2005, SSIS, SSAS, Legacy Components, and Feature packs.
• Generated Enterprise reports using linked reports, sub reports, charts and filters in SQL server reporting services.
• Configuring Replication (Merge, Transactional & Snapshot) to replicate data to regional and remote servers and troubleshooting Replication issues.
• Experienced in implementing and supporting High Availability solutions like Database mirroring, Clustering, Log shipping and Replication.
• Experience in assisting Applications & teams across Remote and Local geographical locations as part of Support.
• Excellent Analytical, Interpersonal and Communication Skills.

TECHNICAL SKILLS

Cloud: Amazon Web Services (EC2, S3, RDS, CloudFormation, IAM, Route 53, VPC, SNS, SES, SWF,SQS, Redshift, EMR)

Databases: MySQL, MSSQLServer 2008R2/2008/2005/2000, ORACLE, MS Access, RDS, DynamoDB

Database Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Analysis Services, Business Intelligence & Development Studio and Erwin

Development skills: Confidential -SQL,PL/SQL,SSIS/SSRS/SSAS, Oracle 8i/9i/10g

Languages: Python, PHP, Confidential -SQL, HTML, XML,CSS, JavaScript, Java

Application Servers: Tomcat, Apache

Reporting Packages: SQL Server Reporting Services (SSRS), Business Objects 6.5/XI, Crystal reports 9/10/11, MS Excel

Operating Systems: Windows98/NT/2000/XP,2003Servers, UNIX/LINUX/UBUNTU

Tools/Methodologies: AWS CLI Tools, PUTTY, Stackdriver, MS Project, SQL Profiler, SQL*Loader, TOAD

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

AWS Cloud Architect

Responsibilities:

• Provided continuous 24/7 on-call support for all AWS integrated production server applications and systems.
• Responsibilities include designing and developing new back-end services, maintaining and expanding AWS infrastructure, and providing mentorship to others on my team.
• Involved in designing and deploying a multitude applications utilizing almost all of teh AWS stack (Including EC2, Route53, S3, RDS, DynamoDB, SNS, SWF, SQS, IAM, and EMR) focussing on high-availability, fault tolerance, and auto-scaling.
• Created alert policies for cloudwatch metrics using stackdriver.
• Created automatic backups for all backend EC2 instances using cloudaware.
• Increasing EBS backed volumes storage capacity when teh root volume is full.
• Transferred data from DynamoDB to RedShift.
• RDS instance created for teh MySQL backend wif its ability to scale and provide other read replicas. Shell automation.Logical design of database for projects on basis of user requirement.
• Enabled one minute detailed cloudwatch metrics instead of 5 minutes default metrics provided by AWS.
• Created S3 backups using versioning enable and Lifecycle policy options to protect objects from accidental deletion, over writing and for moving objects to Amazon Glacier for archiving purpose.
• Created users and groups using IAM and assigned individual policies to each group.
• Created SNS notifications and assigned ARN to S3 for object loss notifications.
• Created load balancers (ELB) and assigned load balancer DNS to Route53 wif failure over and latency options for high availability and fault tolerance.

Confidential, Houston TX

AWS Cloud Architect

Responsibilities:

• Involved in designing and developing Amazon EC2, Amazon S3, Amazon SimpleDB, Amazon RDS, Amazon Elastic Load Balancing, Amazon SWF, Amazon SQS, and other services of teh AWS infrastructure.
• Implemented Security groups for Inbound/Outbound access.
• Load balancers configured for incoming loads and instances created to auto scale and Elastic Search instances.
• Created AWS Multi-Factor Authentication (MFA) for instance RDP/SSH logon, worked wif teams to lockdown security groups.
• Setup specific IAM profiles per group utilizing newly released APIs for controlling resources wifin AWS based on group or user.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL RDS instances.
• Implemented and maintained database security, logins and assigned roles to individual users.
• AWS data backup (snapshot, AMI creation) techniques, along wif data- Confidential -rest security wifin AWS.
• Develop scripts to automate deployment and configuration changes using modern technologies such as Puppet.
• Created Cron jobs for scheduled tasks.
• Reviewed and installed available patches for EC2 backend instances.
• Installed Cloudwatch logs, Stackdriver and OSSEC agents on EC2 backend instances.
• Enabled one minute detailed cloudwatch metrics instead of 5 minutes default metrics provided by AWS.

Confidential, Louisville, KY

SQL Server DBA / Developer

Responsibilities:

• Management of SQL Servers, databases, storage management for databases.
• Management of database objects such as tables, views, indexes.
• Management of users including creation/alteration, grant of system/db roles and permissions on various database objects.
• Involved in writing Transact-SQL command line script for various needs.
• Evaluated data storage considerations to store databases and transaction logs.
• Involved in Migration of SQL Server 2005 to 2008 and also on new hardware wif teh platform of Windows 2003.
• Used DTS/SSIS to perform teh ETL tasks from source to target.
• Tuned teh database to perform efficiently by managing databases.
• For transferring, used data import and Export utility and BCP command line utility.
• Monitoring teh server for High availability of teh servers solving teh raised by user support.
• Participate in implementation of new releases into production.
• Facilitates application deployment and joint effort deployments.
• Tuned Stored Procedures, DTS packages for accuracy of Servers.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Implemented and Scheduled Replication process for updating our parallel servers.

Confidential, Pittsburgh, PA

SQL Server DBA / Developer

Responsibilities:

• Development of Confidential -SQL Stored Procedures for Export & Import of data from databases and Transaction Databases of different agencies.
• Administration of around 15+ SQL server 2005/2000servers. Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.
• Developed DTS packages and schedule jobs for loading data between different sources.
• Creation and maintenance of databases, creating roles and managing user permissions.
• Created Views and Index Views to reduce database complexities for teh end users.
• Code Review for different modules of SQL Technology Team.
• Implement Replication for Reference Data across different Instances of teh application.
• Installation of SQL server Instances and Service Packs. Applying Hot Fixes. Testing and analyzing effects of Server Upgrades and Security Fixes on customized server instances wif Mount Points etc. Implementation of new changes through Change Request.
• Implementing different Development and Test Server instances for teh Application Development Team and to co-ordinate Development and Testing Environments and keep them updated.
• Documented disaster recovery plans and participated disaster recovery drills.
• Reviewed third party tool (Idera) so as to help automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs.
• Performed query tuning, assigned proper Indexes for better performance.
• Provided 24 X 7 dedicated supports for SQL Server production server.

Confidential, TX

SQL Server DBA

Responsibilities:

• Designed and implemented teh database in MS SQL Server 2000 for an outsourced retail client.
• Created teh MS DTS packages for executing teh required tasks. Created teh Jobs and scheduled for daily running.
• Administered teh SQL Servers and teh databases.
• Migrated data of teh products and customers from retail store’s database (SQL Server 2000) by DTS.
• Created Trigger for teh application which would automatically run jobs so dat synchronization between legacy and newly developed system is maintained.
• Designed and implemented teh database in MS SQL Server 2000.
• Created maintenance plans in SQL Agent to backup teh database.
• Implemented Log Shipping Successfully.
• Disaster Recovery Plan, Testing and analyzing and continuous update of documentation.
• Administered teh SQL Server 2K databases of ACA Retail System Confidential ., including Open Office, Open DC, Open Net and Open Store.
• Analyzing transactional logs using Lumigent Log Explorer for potential data issues, DMLs and DDLs.

Confidential

SQL Server DBA/ Consultant

Responsibilities:

• Collaborated wif software engineers, architects, and technology specialists to design database, clustering, and migrations.
• Deployed and Administrated SQL 2000 server on production environment.
• Develop and implement Replication, Archiving, Backup and Recovery strategies.
• Proactively monitor teh Production Database and optimize stored procedures for better performance. Resolve locking conflicts and resource utilization.
• Administer, maintain, develop and recommend policies and procedures for ensuring teh security and integrity of teh company's databases.
• Manage and Create database schemas for Relational Database Systems (optimize index creation, table creation, storage allocations, etc.).
• Ensure all database environments (Development, Staging, QA and Production) are in sync. Define db scripts versioning system to keep track of database versions for all environments.
• Design, review and implement production SQL Server database objects, models and database designs (schema)
• Wrote optimized Confidential -SQL stored procedure to improve performance, preserve referential integrity and provide application functionality.
• Good experience in maintaining Log Shipping, Replication and Clustering.
• Identify and resolve database performance issues, database capacity issues and other distributed data issues.