PROFESSIONAL SUMMARY:

• Highly Motivated SQL server Administrator with 5+ years of IT experience, in Administering and Managing of multiple MS SQL Server and Databases in Production and Per - Production environments, Demonstrated record of trouble-shooting daily operational as well as system capabilities through enhancing performance or implementing innovative technological solutions.
• Installed and configured SQL 2005 throughout SQL 2014 on WINDOWS 2008 systems.
• Expertise in core operational DBA functions including: database migration, database clustering, and database security
• Expertise in performance tuning, database security configuration, and database continuity in both SQL
• Proficient in creating and scheduling jobs, alerts, activity logs, error logs to capture any possible errors
• Thorough knowledge of modifying database structures including tables, stored procedures, views, triggers, user-defined functions. Proficiency in optimizing complex queries for data retrieval and modification.
• Expert in the development of business intelligence reports and analysis for Enterprise users.
• Builds database models, designs database structures and ETL development.
• Manages and designs the reporting environment, including report data sources, security, subscriptions and metadata.
• Experience in DBCC consistency checks and fixing data corruption in application databases
• Experience working with development and operations teams
• Thorough understanding of best practices for database maintenance, including index and file management, backups, failure recovery, database defragmentation, documentation. Ability to analyze disk space requirements and hardware utilization, automate error notification
• Understanding of storage technologies (Disk storage, SAN, NAS, RAID/Striping) and networking (Ethernet, switching, IP, and routing)
• Able to quickly learn new applications, tools, techniques, and procedures; experience writing technical and project related documentation
• Excellent problem-solving skills with strong analytical ability and creative troubleshooting
• Provide 24X7 Production support for the database and application issue

TECHNICAL SKILLS:

Databases: MS SQL server Access Database Nosql Mysql

Languages: T-SQL Shell Script C++ ASAP.NET

Backup Tool: Cold Hot backup RMAN Import/Export

Server OS: Window Server 2003/2008/2008- R2/2012/2016 Linux

EXPERIENCE:

Confidential, Tuscaloosa, AL

SQL Server Administrator

Technical environment: SQL Server 2016/2014/2012, SSIS,SSRS,T-SQL, SQL Profiler, Database Engine Tuning Advisor,, OLAP, OLTP, Windows Server 2012r2/2016, Linux, Visual Studio 2012, RedGate, Idera, Spotlight, Power Shell, VMWare vSphere, and Microsoft Hyper-V.

Responsibilities:

• Successfully Upgraded SQL Server 2014 to SQL server 2016 and Migrated Databases, Jobs and upgraded ETL packages and SSRS and SSIS packages.
• Able to create ODBC connection between SQL and Access databases to import and export table and to create link, improved database performance by creating index and updated statistics of the database

Confidential Silver spring, MD

SQL Server Administrator

Environment: SQL Server 2016/2014/2012 /2008/2088-r2/2005, SSIS,SSRS,T-SQL, SQL Profiler, Database Engine Tuning Advisor,, OLAP, OLTP, Windows Server 2008/2012, Visual Studio 2012, RedGate, Idera, Spotlight, Power Shell, VMWare vSphere, and Microsoft Hyper-V.

Responsibilities:

• Maintaining over 55 SQL Server machines; over 100 instances; over 700 databases
• Installing, maintaining and patched the MS-SQL software; creating, moving, upgrading databases; and performed installation and configuration of Always -ON Availability group, on Windows Servers 2012r2and virtual machine VM Ware
• Creating the SSRS, SSIS packages and developed ETL packages with different data sources (SQL Server, Access Database, Flat Files, Excel source files, XML files etc.).
• Resolved all technical tasks to the satisfaction of client and remained available for the telephonic assistance as needed
• Managed a million data-integration project for financial services firm that consolidated information from accounting applications, third-party market data and internal equities/fixed income applications.

Confidential

SQL Server Administrator

Environment: SQL Server 2014/ 2012/2008/2088- r2/2005, SSIS,SSRS,T-SQL, SQL Profiler, Database Engine Tuning Advisor, OLAP, OLTP, Windows Server 2008/2012, Linux, Visual Studio 2012, RedGate, PowerShell, VMWare vSphere, VMware and Microsoft Hyper-V.

Responsibilities:

• Developed and write stored procedures, functions, queries, and views in Transact-SQL.
• Implemented and maintained Server security and Database rules and audits; maintained state of audit readiness; problem resolution and Implemented network encryption and SQL Server Transparent Data Encryption
• Constructed SSIS packages tested and implemented to import-export OLEDB sources.
• Effectively handled project and meet deadline of server upgrading and Database Migration

Confidential

SQL Server Administrator

Environment: SQL Server 2012/2008/2088- r2/2005, SSIS,SSRS,T-SQL, SQL Profiler, Database Engine Tuning Advisor, SQLDoctor, OLAP, OLTP, Windows Server 2008/2012, Visual Studio 2012, RedGate, PowerShell, VMWare vsphere, VMware and Microsoft Hyper-V.

Responsibilities:

• Maintained over 100 SQL Server machines; over 300 instances; over 1200 databases
• Monitored database system performance and suggest optimizations as needed
• Managed and auditing user access to DEV, QA and PROD database platforms
• Supporting development staff by advising in data design, optimization, and tuning data access queries for maximum performance
• I have joined as trainee and within 6 month promoted as junior DBA.
• Designed a successful backup strategy, SQL server Mirroring, Logshipping and configured SQL Server Failover Cluster.