SUMMARY

• Over 15 years of Information Technology experience on a wide variety of platforms, hardware, and operating systems across several industries as an Architect, Consultant and Database Administrator.
• Possess and maintain a deep understanding of IaaS and PaaS services offered on cloud platforms and understand how to use them to design solutions for complex business problems.
• Good experience in designingarchitecture, deployment and migration sites from the physical environment to the AmazonCloud on Windows and Linux Servers.
• Coordinated as part of the change process acceptance of all production systems into the operational environment ensuring that appropriate support and service levels can be met to defined standards.
• Experience in designing architecture, deployment and migration sites from physical environment to Amazon Cloud.
• Good understanding and knowledge of primary AWS Services (EC2, VPC, CloudWatch, Route 53, S3, ELB, IAM, RDS).
• Provided support, leadership, motivation and educate staff in the skills required for supporting the maximum productivity.
• Design, deploy and maintain enterprise class security, network and systems management applications within an AWS environment.
• Worked with customers to develop solutions that involve the deployment of AWS.
• Thorough knowledge of best practices and market trends pertaining to Cloud and mentor team to build necessary competency.
• Managed the team key performance indicators, set priorities and allocate the resources to achieve agreed goals.
• Extensive experience in maintaining AWS EC2 (Elastic Cloud Computing) resources like instances, EBS volumes, snapshots, Elastic Load Balancers (ELB), VPC, AMI's, Security Groups, Rout 53, Lambda, Elastic IP's, Key pairs, RDS, Auto - Scaling, IAM and Amazon Cloud watch for different zones in different environments
• Hands on experience provisioning, operating, and maintaining systems for high availability running on AWS utilizing Linux, Windows etc.,
• Has the ability to work in a fast paced environment, Good team player and can work independently.

PROFESSIONAL EXPERIENCE

Confidential

AWS Solutions Architect

Responsibilities:

• Collaborated with customers and translate business needs into data strategy, data architecture solutions and designs.
• Migrated existing databases from on-premise to AWS using various tools including but not limited to AWS Data Migration Services and AWS Schema Conversion Tool.
• Participated in planning, implementation, and growth of our infrastructure on Amazon Web Services (AWS).
• Developed innovative database solutions that increase scalability and performance and minimize downtime; perform modeling to assess and enhance database capacity and performance.
• Created and maintain a central repository of all data architecture artifacts including data dictionaries, database administration procedures, scripts, and security controls.
• Designed virtual private cloud environment including server, storage instances, subnets, availability zones etc.,
• Developed high level designs, plans and estimated amount of effort required to deliver on time and budget.
• Guided the design and implementation of AWS-hosted databases for existing on-premise backend databases.
• Developed architectural blue prints and detailed documentation.
• Setup Amazon AWS for the open source technologies. Included the creation of AMIs and setting up all in-house infrastructure on AWS for PCI compliance.
• Architected the linear scalability cloud back-end using AWS EC2 instances, custom configured AMIs, with cloud watch monitored auto scaling groups for the web, push messaging and queue processing computing groups. Secured by locked down VPCs, tight security groups and network monitoring.

Confidential

Data Architect and DBA

Responsibilities:

• Established data standards and policies, data modeling, systems architecture design, and migration systemarchitectures to ensure access to and integrity of data assets for security and confidentiality compliance.
• Provided 24x7 production support including overnight processing issues.
• Determine technical/non-technical training requirements for team and makes recommendations to infrastructure and operations manager.
• Manage dba operations including staff recruitment, supervision, scheduling, development, evaluation and disciplinary actions.
• Follow up on various technical problems with third party partners and outsource providers.
• Coordinate production releases/code changes and postpone or reject them if there are any scheduling conflicts or technical inconsistencies.
• Tuning and optimizing queries by altering database design, analyzing different query options and index strategies.
• Review code changes and reject them if changes don’t meet company code standards or standard of code practice.
• Conduct server health checks on high end sql server environments.
• Provide administrative direction and support to daily activities of dba team.
• Carry out technical requirement gathering, gap analysis and documentation of existing systems.
• Regular monitor of servers which includes backup job monitoring, disk space monitoring, block monitoring and troubleshoot all issues on regular basis.
• Providing technical database consultancy to application development and support staff.
• Documenting different documents including production data change requests, incident reports, and financial data change requests.

Confidential

Microsoft Database Administrator

Responsibilities:

• Tune sql server by examining current workloads and hardware making improvements and measuring results.
• Performed database administration functions including security access, performance tuning, capacity planning, and database replication/ backups for recoverability.
• Mentoring developers on how to write better queries, optimize their applications and to become junior dba’s.
• Developed and implemented sql server fail over clustering for production server.
• Collaborated with developers to rewrite and tune long running queries to cut execution time, ease database load and improve scalability.
• Capacity planning, sizing and database growth projections and coordinate with storage and Intel teams for expanding drive space on production servers.
• Wrote t-sql queries for various application/user needs. Developed number of stored procedures and triggers for implementing business rules.
• Involved in project management via engagement process. Initiated several project meetings by cross functional team effects in problem solving, project deployments, deliverables and project plans.
• Provide advanced scripting techniques to automate processes and/or troubleshoot developer’s code to provide for database queries.
• Participate with design of stress, interoperability, integration and performance tests for new applications.
• Work to ensure maximum availability (99.9%) of all databases.
• Perform maintenance and implement enhancements to current inventory of database based solutions.
• Analyze and translate business needs and opportunities into written database systems requirements.

Confidential

SQL Server Consultant

Responsibilities:

• Used E-R diagram and flow charts for database conceptual and logical design and maintained Referential Integrity.
• Managed inventory of database instances in use
• Developed alerts system in case of SQL server job failure.
• Extracted Data from different SQL Servers using Linked Servers
• Migrated data from SQL Server 2000 to SQL Server 2005.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Scheduled backups and performed restore operations for system test data depends on testers’ requirement.
• Creating and scheduling SSIS packages in SQL Server 2005 in Business Intelligence Studio to transfer data.
• Administered MS SQL Servers by creating User logins and assigned them proper permissions, observing all process running on the server making sure server will run at its best.
• Ensured the efficient and timely resolution of database SQL issues and trouble tickets.

Confidential

Analyst Programmer

Responsibilities:

• As a team member, involved in application development using ASP.NET and SQL Server.
• Involved in requirement gathering from the client and designed flow charts and dataflow diagrams.
• Used ADO’s to connect to database and for accessing and modifying data.
• Developed ActiveX controls for representing layout diagrams and show the status of devices.
• Involved in the development of customize data tables according to the client specifications.
• Involved in testing and deployment of the application.
• Installing the application at the client place and training.
• Created very user friendly and interactive web forms using ASP.NET.
• Used crystal report for data gathering and for customized event reports.
• Designed the database using SQL Server.