Sql Dba Project Manager

Full Name: Meron

Email: **************@*****.***

Phone: 512-***-****

MS SQL DBA

PROFESSIONAL SUMMARY

●A Microsoft certified SQL server (DBA) with almost 9+ years IT experience: designing, coding, testing, and supporting next-generation database solutions in SQL Server environment.

●Possess strong communication and problem-solving skills developed through a variety of projects. Offer proven ability in team work and proactive system support.

●Experience in Installing, configuring, administration and Maintenance of mission critical client databases in SQL server 2012, 2014, 2016, 2017 and 2019 versions.

●Good experience in configuring the SQL Server in AWS Relational Database Management system and in EC2.

●Extensive Experience in Upgrading SQL Server (In place Up and Side by side Upgrade) based on application compatibility and fixing the orphan users.

●Experience in implementing SQL Server security and Object permissions like creation of users, granting permissions and assigning roles to users.

●Deployment, administration and operational support of production, development and test environments utilizing proper change management and other ITIL best practices using ticketing tools.

●Good experience implementing and troubleshooting High Availability of database servers using Replication, Log Shipping, Database Mirroring, failover clustering and Always ON AG.

●Strong experience on understanding and creating the server level and database level roles as per business requirement.

●Experience in Configuring and Scheduling SQL Server agent Jobs, Alerts, operators, Maintenance plans, Database Mail Configuration, facets and Transparent Data Encryption.

●Extensive experience with Monitoring, Performance Tuning and analyzing DB performance issues.

●Strong experience on designing and implementing the backup and disaster recovery strategies as per RPO and RTO values.

●Experience on configuring and maintaining Full backup, Transactional log backup, Differential backup and creating the maintenance plans for index rebuild, index reorganize based on fragmentation.

●Strong experience on identifying and troubleshooting database health, integrity checks and fixing them.

●Experience in Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.

●Created reports, sub reports, charts, Tablix, Matrix, Hyperlink reports.

●Created jobs, alerts to run SSAS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job

CORE TECHNICAL SKILLS

QL Server 2012-2019, T-SQL, AWS-RDS, AWS-EC2, IDERA SQL diagnostic Manager, SQL safe 6.0, Red-gate SQL Compare 10 and Data Compare 10, DataEdo, ERWIN, SSDT, Azure, SSIS, SSRS, SSMS, DTA, JIRA, RAID, MYSQL, LiteSpeed, AZURE VM, Azure managed instance, MuleSoft, Salesforce, API.

Education & Training:

Bachelors in:

Certificates:

EXPERIENCE AND ACHIEVEMENTS

First American Financial, California, United States August 2019– Present

SQL DBA Administrator

Responsibilities:

●Installing, configuring, administering and securing production and non-production servers (clustered and non-clustered).

●Upgrading SQL Server 2016 to SQL server 2019.

●Experience in implementing windows cluster across multiple availability zones and Implemented SQL Server 2016 Always On availability group in AWS.

●Experience in setting up database transactional replication for reporting servers, Using Backup and restore methods.

●Experts in Database refresh from prod to lower environment as per the business requirements. Automated quarterly/monthly database refresh.

●Managed and Involved in SQL performance Tuning, identifying locking and blocking issues using Native and Third-party tools to enhance and boost performance of SQL Dbs.

●Managed and Implemented Ola Hallengren's Industries best SQL server maintenance plan and created schedule for all environments.

●Managed SQL server Logins, Database users & roles and involved in Daily User Maintenance.

●Created Database Maintenance jobs to perform full & transaction log Backups and scheduled them with the SQL Server agent job scheduler.

●Monitor database growth activities & Troubleshoot Transaction Log Issue.

●Created and configured mirroring for Disaster Recovery

●Providing weekly status information on all projects to Project Manager

●Wrote and debugged Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements.

●Logical and Physical design of database for projects on basis of user requirements using ERWIN

●Reporting on a weekly basis to the project manager.

●Extensively worked on troubleshooting and fine-tuning of databases for optimal performance.

●Worked with Performance Tuning/Query tuning, execution plans, trace flags and SQL Profiler

●Installation of Service packs to all environments.

●Used log shipping for synchronization of databases.

●Designed and developed ETL process using SSIS to load data from various sources like MS Access and SQL Server 2014, Oracle database

●Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS)

●Good understanding in database and data warehousing concepts (OLTP & OLAP).

●Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases

●Worked on BCP for data uploading module and created SSIS packages for data transfer & transform across locations and multiple data sources as per requirement.

●Created new tables, stored procedures and triggers using T-SQL.

●Refactored and Fine-tuned the queries and Stored procedures in T-SQL.

●Performing DB backups, DB refresh, DB restores, clean-up, statistics update

●Installed and configured MS SQL Servers in Virtual Environments using VMWARE.

●Analyze the Execution plans and recommend/implement a better execution plan.

●Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.

●Experience supporting AWS DB in production and Development environment

Environment: Windows 2008-2012R2, SQL Server 2008-2016, AWS-RDS, AWS-EC2, IDERA SQL diagnostic Manager, SQL safe 6.0, Red-gate SQL Compare 10 and Data Compare 10, Visio 2010, DataEdo, ERWIN.

EliLilly, Indiana, United States December 2015- July 2019

SQL Server Database Administrator

Responsibilities:

●Installed and Configured various editions and versions of SQL Server in standalone, and clustered nodes

●Installed, and Configured SQL Server Fail-Over Cluster for SQL Server 2016.

●Applied service packs, hotfixes and cumulative updates

●Upgraded SQL Server 2012 Database into SQL Server 2016.

●Created and maintained logins, Users, Roles and managed security of the database.

●Implemented Disaster recovery plan by performing routine backups and restore

●Taking Full, Differential and Transactional log backups and setting automated jobs.

●Migrated data using Import/Export, bulk, backup-restore, DTS, SSIS, Detach/Attach

●Performed data Extracting, Transforming and Loading (ETL) from different data sources.

●Rebuilding /reorganize indexes to reduce fragmentation and enhance SQL server performance

●Created triggers, views and stored procedures,

●Implemented database Maintenance plans, scheduled automated SQL Server jobs, Created Alerts, Operators, Notifications and configured database Mail.

●Hands on experience monitoring and performance tuning using Tuning Advisor, SQL server Profiler, Activity monitor, Windows performance monitor, DBCC, DMVs, Stored procedures

●Working with Resource Governor to control and allocate CPU and memory resources depending on the priority of applications.

●Configured and Managed Database High Availability: Replication, Database Mirroring, Log Shipping, Failover Clustering and Always On availability group.

●Scheduled reports using SSRS to generate daily, weekly, monthly, quarterly reports

●Worked in a team with integrated Developers, CAB (Change Approval Board) and Disaster Recovery Planning team.

●Experience in contacting Microsoft and other vendors for product and technical support.

●Providing resolution to assigned tickets (JIRA, Team Track and Service Desk) as per their severity and meet the deadline before SLA is due.

●Experience in Agile projects with a solid foundation in Software Development Lifecycle (SDLC).

Environment: Windows 2003-2012R2, SQL Server 2008-2014, IDERA SQL diagnostic Manager, Red-gate SQL Compare 10 and Data Compare 10, Visio 2010, SSDT.

Sherwin-Williams, Ohio, United States January 2013— December 2015

SQL DBA

Responsibilities:

●Created and updated databases, tables, stored procedures, triggers, functions, and views.

●Configured, administered, and troubleshoot multiple databases in production and staging environments in clustered and standalone environments.

●Prepared documentation for disaster recovery plan.

●Involved in installing failover clustering on multiple nodes.

●Implemented database mirroring and log shipping

●Planned backup strategies, scheduled backups, and performed restore operations.

●Managed security of SQL server databases by creating logins, creating database users, creating roles, assigning proper permissions, creating server and database audits.

●Worked on creating, reorganizing, and rebuilding indexes.

●Worked on database space management, performance monitoring, and alert management.

●Planned the location of files and increased the size and number of files.

●Performed tasks of query optimization, troubleshooting client/server connectivity issues, and performance tuning.

●Monitored and troubleshoot database and server performance at system-wide scale and effectively identify network, databases, Memory, CPU, Disk Space, and I/O related bottlenecks.

●Transferred data between several servers using BCP and DTS.

●Generated reports extensively using SSRS.

●Providing resolution to assigned tickets (JIRA, Team Track and Service Desk) as per their severity and meet the deadline before SLA is due.

Environment: Windows 2008-2012R2, SQL Server 2008-2008R2, SQL Server 2012 SSMS, Profiler, Extended Events, Perfmon, RAID

Contact this candidate