Database Administrator Server

Professional Summary:

Over * years of experience in SQL Server 2008R2, 2012, 2014 and SQL Server m.2016 database administration.

Backup and restoration of databases, automating Administration, Security maintenance, and troubleshooting client-server applications.

Knowledge on Database Analysis/Design/Normalization/Manipulation processes using SQL Server.

Monitoring and tuning SQL Server performance with multiple tools including Performance Monitor, SQL Profiler, Event Viewer, and Index Tuning Wizard to achieve better performance, accessibility and efficiency.

Excellent analytical & interpersonal communication skills, able to work both in teams and individually.

Expertise on SQL Server Replication models, Stored Procedures, Triggers, Indexes, Views, Locking, and Analysis Services, OLAP.

Setting up the migration from SQL Server 2008 R2 to SQL server 2012 and 2016.

Reporting services in SQL server

Expertness in trouble shooting database issues like space issues, deadlocks, performance and blocking.

Created and managed of Logins, Users, Roles and permissions

Sound knowledge stored procedures, Indexed views, User Defined Functions (UDL), Triggers Distributed Queries and Common Table Expressions.

Dynamic problem-solving ability, team player, detail-oriented, and quick learner. Strong analytical and interpersonal skills, strong work ethic and effective at meeting project objectives and deadlines in fast-paced environments.

Education:

Microsoft Certified MSSQL Server 2012/2014 Database Administrator

PROFFESSIONAL EXPERIENCES

Alcon, HOUSTON, TX (September 2018– Present)

Role: SQL Server DBA

Responsibilities:

Managing of Logins, Users, Roles and permissions

SQL 2008R2 Database support, troubleshooting, planning and migration. Resource planning and coordination for application migrations with project managers, application dbas and web app teams.

Modifying the database structure, as necessary, from information given by application developers.

Planning for backup and recovery of database information.

Performed installation, configuration and upgrade of SQL 2008R2, 2012,2014,2016,2017.

Failover cluster testing on servers as well as monitoring and backup.

Replication, mirroring, and Log Shipping with SQL Server Management Studio as well as basic troubleshooting.

Creation and scheduling of Maintenance plans (database and log backups and cleanups), Created tables and performed data and restores for successful migration.

Proactively managed Microsoft SQL Server instances at the corporate office by developing Microsoft SQL scripts for creation and upgrade of databases, maintenance plans, user logins, automation of network and server monitoring with exception reporting via Database Mail notifications, and a SQL Server failover system.

Worked on SQL Server 2016 migration from SQL Server 2014.

Experience in creating, modify and scheduling of SQL server Jobs.

Troubleshoot application database issues/ maintain large database.

Environment: SQL Server 2016, SQL Server 2014, SQL Server 2012 SQL server

2008, 2008R2 Enterprise

Goodman, Houston TX (March 2016 – July 2018)

Role: Junior SQL Server Database Administrator

Responsibilities:

Performed backup using backup compression and Data compression in MSSQL Server 2008R2 on clustered environment.

Installed and configured SQL Server 2008R2, 2012, 2014 on Windows server 2008R2 and Windows 2012R2 Server, applied service packs and cumulative updates released from Microsoft.

Worked with Capacity planning tools, checked CPU and memory utilization, disk contention, transactions per second etc.

Experience in Implementation of Production, Integration and Development environment,

Designing, testing and managing disk\tape Backups and Recovery strategies.

Installed and configured The SQL Server Reporting Services (SSRS) and maintenance of the Reporting Servers.

Implemented and tested the point in time recovery of the production databases.

Monitored and maintained SQL Servers in Production, QA, Test and Development Environments.

Check consistency of databases using the DBCC commands. Creating new procedures using Dynamic SQL and Table Variables.

Managing of Logins, Users, Roles and permissions

Set up SQL Mail, Created Jobs to Automate & Scheduled tasks.

Implementing of Automated Backup and Database Maintenance / Cleanup jobs

Environment: Windows 2000/2003, SQL Server 2005 and 2008R2, Windows Enterprise Server 2003, SSRS Microsoft Reporting Services.

Contact this candidate