SUMMARY

• Enterprising SQL database administrator with 8.5 of experience in installing and migrating databases with optimal precision.
• Adept at tuning and implementing DMS installations and upgrading applications for improving the performance of numerous systems.
• Proficient in testing database management systems and fixing errors for increased productivity.
• Installing SQL Server and troubleshooting.
• Applying the latest service pack on SQL Servers.
• Upgrading and migrating SQL Servers from on - premises data center to another data center and on-premises data center to AWS Cloud.
• Backing up the data from various servers with a Monitoring tool, including full backup, Differential backup, and Transactional backup. Database refresh from production to development.
• Developing successful Backup strategies based on Recovery models.
• Creating maintenance plans and scheduling jobs.
• Knowledge on SSIS Packages and creating the jobs.
• Installing and configuring SSRS, deploying the SSRS packages to report server, SharePoint.
• Creating Data driven subscriptions to generate SSRS reports.
• Experience in importing and exporting SQL tables, Importing flat files into databases.
• Shrinking Data and log files.
• Disaster recovery planning and Maintenance.
• Creating a Disaster recovery site for the production servers.
• Best exposure on Log shipping Mirroring, Replication configuration, Always on availability, clustering, and troubleshooting.
• Managing database users and security.
• Creating users and setting up privileges as per their requirements.
• Implemented Log Shipping & Mirroring Techniques.
• Knowledge on Always on availability group.
• Restoring DB backups in SQL Server from various Backup tools like Symantec NetBackup tool and Azure VM Migrate tool.
• 3+ Years of Experience in cloud computing, Storage and bandwidth costs, SLAs, backup, and disaster recovery.
• Design highly available, cost-effective, and fault tolerant systems using multiple EC2 instances, Auto Scaling, Elastic Load Balance, and AMIs.
• Utilize EBS to store persistent data and mitigate failure by using snapshots.
• Design AWS CloudFormation templates to create custom-sized VPC, subnets, and NAT to ensure successful deployment of Web applications and database templates.
• Design roles and groups for users and resources using AWS Identity Access Management (IAM)
• Provide highly durable and available data by using an S3 data store, versioning, lifecycle policies, and Creating AMIs for mission-critical production servers for backup.
• Utilize Amazon Glacier for archiving data.
• Manage network security using Security Groups and IAM.
• Use Amazon RDS to manage, create snapshots, and automate the backup of the database.
• Good understanding of ELB, general networking principles, firewalls, routing technologies, and DNS (Route53)
• Utilize CloudWatch to monitor resources such as EC2, CPU memory, Amazon RDS DB services, DynamoDB tables, and EBS volumes; to set alarms for notification or automated actions, and to monitor logs for a better understanding and operation of the system.
• Focus on continuous integration and continuous deployment and promote enterprise solution deployment assets to target environments.
• Document system configurations, Instance, OS, and AMI build practices, backup procedures, and troubleshooting guides, and keep infrastructure and architecture drawings current with changes.
• Create training modules designed to assist and train onboarding new employees.
• Excellent problem-solving skills, including the ability to foresee problems before they occur.

TECHNICAL SKILLS

Cloud Infrastructure: Amazon Web Services (AWS) - VPC, EC2, S3, CloudWatch, RDS, CloudFront, IAM, DynamoDB, EBS, Auto Scaling, Glacier, CloudFormation, Route53, SNS & SQS

Databases: SQL Server 2005, 2008,2008R2, 2012, 2014 and 2016.

Operating Systems: Windows XP, 2000, 2003,2008, 2008R2, 2012, 2012 R2, Linux.

Languages: T-SQL, SQL

Tools: SSMS, SSCM, SSRS, SQL Profiler, Rock-solid.

PROFESSIONAL EXPERIENCE

Confidential

MS SQL Cloud DBA & AWS Cloud Engineer

Environment: SQL Server 2008,2008R2, 2012, 2014, 2016. Windows 2012, R2, 2016, 2019 Server.

Responsibilities:

• Providing SQL support for critical applications like Confidential Internet banking and Mobile app along with multiple Financial and loans applications.
• Maintaining healthy backups for critical databases and fixing backups failures when occurred.
• Designing and supporting databases refresh activities for production to UAT and dev environments based on client requirements.
• Working on user created incidents from Service now with in the SLA
• Fixing the log space issues for the production databases and monitoring the disk space alerts.
• Installing the Baseline/Security patches for the SQL servers which are certified from the Microsoft
• Database restoration as per Application team’s requirement in multiple environments.
• Implementing and managing Log Shipping, Replication and Mirroring for Reporting purposes and for Disaster Recovery Purposes on various databases.
• Lead the planning and execution of Security audits for all applications hosted on SQL servers and fixed the non-compliances from application teams.
• Working on SNOW Incidents, requests, Problem task and providing the SQL support for all critical changes over weekend releases.
• Fixing the blockings in the databases and performance related issues for production applications.

Confidential

AWS Solution Architect & MS SQL Cloud DBA

Environment: SQL Server 2005, 2008,2008R2, 2012, 2014, 2016. Windows 2102, 2102 R2 Server.

Responsibilities:

• Migrating the end to end environment includes Windows server, SQL databases and applications hosted on that database from on premise to cloud (AWS, Confidential cloud) and Cloud to on premise.
• Involved in the designing and creating Migration plan with High level documentation with clients and project team.
• Collaborating with the end clients on planning and execution of the Migrations for their applications/Databases along with down time.
• Performing the pre-migration and post migration checks for the databases and applications and providing support for post migration issues.
• Installing the SQL Server and Confidential applications like Practice management (PM) and EHR (Electronic health record) with their ancillary products.
• Updating the windows registry and maintaining the backups of the registry for migration purposes.
• Troubleshooting the Application issues and databases issues post migration.
• Creating logins in the cloud for applications/Databases and assigning the access to users as per their requirements.
• Using various cloud technologies and tools from AWS, Azure, Microsoft and Confidential cloud for storage transfer.
• Attending meetings for troubleshooting Priority issues during and post migrations with end users.
• Creating and designing of the Database configurations and maintenance plans in the SQL Server.
• Modifying the application stored procedures and tables.

Confidential

MS SQL DBA & AWS Cloud Admin

Environment: SQL Server 2005, 2008,2008R2& 2012, Windows 2008, 2008R2, 2102, 2102 R2 Server, AWS Cloud platform.

Responsibilities:

• Maintaining the SQL servers in the AWS cloud Platform.
• Migrating SQL Servers and databases from On-premise to AWS and also from one region to another region in AWS.
• Troubleshooting the Application issues and databases issues post migration.
• Working on performance issues of the databases and providing support to the application team in fine tuning T-SQL queries.
• Updating the latest service packs for the SQL Servers and fixing the compliance issues.
• Creating the EC2 instances as per client requirements.
• Working on Infrastructure creation in the AWS cloud with multiple teams
• Working on various tools like S3, EC2, IAM, RDS, Route 53, Snow ball.
• Creating and modifying the Security groups, firewalls, NAT.
• Maintaining healthy backups and providing support in case of backup failures and in the restoration process.
• Extensively working with end users on fixing their issues in SQL server administration.

Confidential

MS SQL DBA

Environment: SQL Server 2005, 2008,2008R2& 2012, Windows 2008, 2008R2, 2102, 2102R2 Server, AWS Cloud platform.

Responsibilities:

• Performing the health checks and maintaining the databases healthy in the SQL Server.
• Troubleshooting the databases, log and disk space issues.
• Providing the extensive support for SQL server databases across the global regions like APAC, Latin America and North America.
• Installing and SQL Servers and updating the service packs on it as per project releases.
• Configuring the Linked servers and fixing issues of connections in linked servers and ODBC connectivity
• Creating and scheduling backup\restore strategies, maintenance plans to maximize the availability of the database while maintaining the DB Integrity.
• Working on performance issues of the databases and providing support to the application team in fine tuning T-SQL queries.
• Configuring and supporting issues of log shipping, DB Mirroring and replication.
• Migrations and upgrading the SQL servers to latest versions.
• Creating the SQL and Windows authenticated logins and assigning permissions as per users requirement.