MSSQL DB Admin & Azure DB engineer, AWS Engineer

Summary

Having 12+ years of IT experience in Database Administration (DBA) on Installing, Creating, Migrating, Upgrading, Patching, Tunning and Capacity Planning for different versions of dbs on Linux, AIX, Solaris and Windows Platforms.
Hands on Experience in Database Administration activities like Database maintenance, Security and regulatory compliance, Disaster recovery (Log shipping, Replication, Database Mirroring, Always on availability group, failover cluster, Distribution Always ON), Design and performance improvement, Documentation, Datawarehouse (SSIS, SSRS (For reporting and analysis data)) and ETL
Having systematic and organized approach with excellent communication and problem-solving skills for increased efficiency and competence.
Experience in Relational Databases (SQL) such as OracleDB, SQL ServerDB and PosgreSQL Databases.
Experience in Non-relational Databases (NoSQL) such as CassandraDB, MongoDB and Couchbase Databases.
Interpersonal Skills with the ability to work as an individual and a team player.
Experience in Installation and Configuration of Golden Gate replications by creating extract process, extract pump, and replicate in different versions.
Good hands-on experience in Oracle Applications E-Business Suite (APPS DBA)
Strong experience in Stored Procedure, User Defined Function, Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, CTE, temporary tables, User Defined Functions, views, indexes, query writing and SQL joins. Performance Tuning and Query Optimization.
Performed in using different tools like MS SQL Profiler, Database Engine Tuning Wizard, and Windows Performance for monitoring and tuning SQL Server performance.
Performed in importing exporting different data sources like Oracle/Access/Excel/CSV etc. using SSIS.
Solid Experience with creating and managing ETLs for Migration
Involved in Report Generation using SSRS and Excel services and deployed them on sharePoint Server
Expert Knowledge and experience in authoring, managing and deploying reporting solutions using SQL Server Reporting Services
Experience in managing Oracle RAC, Data Guard, OEM Grid and Backup & Recovery using RMAN backup utilities.
Extensive in SQL Server and SSIS (Integration Services) package design, development, and deployment using SQL 2016 advanced features in Control flow, data flow, Error Handling and event handling.
Migrated of DTS Packages to SQL Server Integration Services (SSIS) from Lower Version (2000/2005) to Higher Version (2005/2008/2012) and troubleshoot migration issues.
Expertise in developing SSIS Packages and using data transformations and deploying them on various production servers.
Extensive experience with Warm Standby (PostgreSQL 8.x and earlier), and Hot Standby (PostgreSQL 9.x and greater) in PostgreSQL DB.
Experience with installing, configuring and monitoring Apache Cassandra cluster
Experience in implementing multi-datacenter cluster in Cassandra.
Develop, implement, and maintain change control and testing processes for modifications to databases. Ensure all database systems meet business and performance requirements. Creating and scheduling Jobs in MySQL, ETL, deploy SQL patches, Perform Data Migration Activity
I Have solid experience with a high Volume OLTP environments
Develop dashboards and visualization by using Tableau for decision makers.
Maintained positive communications and working relationships at all business levels.
Hands on experience on all kind of monitoring tools like GMI/Splunk/i5/Compass
Good medium level experiance in Postgres, Sybase,Power BI, Oracle Database and linux
Solid experience on few major services from cloud platform like AWS and Azure
Installed SQL Server Reporting Services (SSRS) to create a common report template and using SSRS data source connections inside the report.
Azure Cloud professional with strong experience in migrating resources to Azure, Azure Administration, Azure Infrastructure Operations, and end to end Project Management.
Effectively managed and reduced cost by effectively monitoring databases elastic pool. Configuring Azure Site Recovery for DR and Azure back-up on-premises/Azure Environment.
Lead design, architecture, and deploy of solutions in Azure platform.
Migrate SQL Server Databases to Microsoft Azure hosted DBs, Managed instances. Configured High Availability Solution; Always-On, Log Shipping, migration, patching, troubleshooting, optimization, maintenance (modelling, High-Availability (HA) and Disaster Recovery (DR)).
Performed Database Migration from On-Premises SQL environment to Azure Database in cloud Manage database security and users in Active Directory, ensure Database Integrity and setup maintenance plans via SQL Agent.
SQL Databases from On-Prem to AZURE, configure Geo-replication for High availability, Azure Site Recover and manage database on Elastic pools and Manage instances
Create Data Models for new and modernized legacy Databases, implement database design following best practices to maximize performance and reduce data redundancy.
Provided high availability for IaaS VMs and PaaS role instances for access from other services in the VNet with Azure Internal Load Balance
Deployed Azure IaaS virtual machines (VMs) and Cloud services (PaaS role instances) into secure VNets and subnets
Experienced with deployments, Maintenance and troubleshooting applications on Microsoft Cloud infrastructure Azure.
Designed and built cloud service models including Infrastructure-as-a-Service, Platform-as-a-Service, and Software-as-a-Service.
Experience with Microsoft Azure cloud for multiple clients and customers of General Blue Corporation
Configured SSIS packages to change the connection string and update the value of a variable to transform data as per Business Required Document.
Responsible for data transformation from Excel, flat file to SQL server by using BCP and data transformation services DTS utilities.
Resolve blockings, locks, and deadlocks using Activity Monitor, DMVs and SQL profiler.
Schedule and scripting DBCC commands to run daily and weekly basis in order to identify the health and performance of SQL server databases.
Successfully lead the SQL Server Migration Projects from one datacenter to another datacenter around 1500 DB Servers as part DC consalidating by separating L&S, V2V & P2V
Experience installing SQL server RDS instance in AWS EC2 server
Experience working with Azure SQL Database Import and Export Service
Provided guidance and implemented PostgreSQL and MSSQL database solution in AWS (Amazon Web Services) EC2 & RDS environments.
Experience in regular maintenance activities like Query SQL tuning, statistics update, Index rebuild, log file monitoring, temp DB monitoring, handling blocking, deadlock resolutions and fragmentation issues.
Solid Experience of SQL 2016 Query store and Live statics for performance analysis.
Identify data entry, retrieval, change, and delete issues, and work to ensure a high level of data availability while working to meet business requirements for project completion
Participated in the Agile development lifecycle including sprint planning, story writing, task planning and project coordination

Expectations

Hi,

Please consider my application for the MSSQL Server Database Administrator, AWS Cloud Admin & Azure Admin position.I believe my skillset & experience match well with your needs , I have included my detailed resume for your review and look forward to discuss more in detail about this position.Skilled SQL Database administrator with 12+ years of in the IT industry along with AWS cloud admin & Azure admin activities,Highly adept at handling various responsibilities by prioritizing my tasks, establishing clear deadlines and creative solutions to eliminate obstacles, My experience has equipped me with the necessary tools to succeed in this position .

Microsoft SQL Server database administrator
AWS cloud Admin
Azure Admin
Microsoft SQL Server Development

I am ready to embark on a new career path that offers new challenges for me to put my skills to use Please take a look at my enclosed resume for more details about my work experience and qualifications. I'd really like to speak with you more about the position, and I look forward to hearing from you soon.

Sincerely,

Employment Preferences

Expected Base Salary

**0,000 USD

Expected Hourly Rate

** USD/hr

Academic Degree

Experience

Skills

• MSSQL Database Admin
• Azure DB Engineer
• AWS Engineer