SUMMARY

• I am currently responsible for ensuring High Availability (HA) of all SQL Server databases, ensuring that all databases are recoverable in disaster situation (DR) and that all databases meet or exceed customer requirements.
• I am working as the primary responder to any incident related to database issues, performance issues and security issues.
• I am currently seeking a SQL Server DBA position in where I can utilize my experience and move on to the next level of my career path.

TECHNICAL SKILLS

• Microsoft Windows Server 2012R2, 2016
• Microsoft SQL Server (2012, 2016 and 2017), Microsoft SharePoint
• Data Tools (Visual Studio), Management Studio, Database Diagram, Activity Monitoring Tool, SSAS. (SQL Server Analysis Service), Microsoft Power - BI with SSRS (SQL Server Reporting Service).
• New Query (T-SQL), DBCC, DMV, ETL (Extract Transform and Load: SQL Server Integration Service), SSMA - SQL Server Migration Assistance, Database Mail & Alert/Notification.
• Other Relevance: SQL Server Activity Monitoring, Native Client (ODBC, OLEDB), SQL Server Profiler, Database Engine Tuning Advisor, Data Tools (Visual Studio), Management Studio - Database Diagram - Activity Monitoring Tool, SSAS (SQL Server Analysis Service), Microsoft Power-BI with SSRS (SQL Server Reporting Service), Service Manager, NetBackup, Tape backup.
• High Availability & Disaster Recovery: Windows Failover Cluster, AlwaysOn High Availability on VMware/vSphere and Cloud platform.

PROFESSIONAL EXPERIENCE

SQL Server Database Admin & IT Support Rep

Confidential, Bethel Park, PA

Responsibilities:

• Working and supporting various groups and team for SQL Server 2014/2016 managing, installing and configuring on Windows Server 2012R2/2016 environment (WFC).
• Managing account, creating login, mapping users for database and server level access as needed.
• Working day to day to manage security; manage windows authentication and SQL Server authentication login/user as require.
• Implementing and Maintaining Log Shipping, Windows Failover Clustering, Database Mirroring, AlwaysOn as Disaster Recovery and High Availability solution.
• Design and Implement Database Backup Restore & Disaster Recovery Strategy.
• Database Archiving / Partitioning, data mapping, creating multiple file-file group for better database and server performance. Database Professional, Performance Tuning, and Disaster Recovery.
• Troubleshooting SQL Server for database, application users respective and provide solution within timely fashion. Schedule SQL Server Agent Jobs, SQL Server across multiple Servers with automatic and manual execution.
• Working directly with vendors to allow application integration with our environment between front-end users and back-end serves/databases.
• Working for database and SQL Server vulnerability scan, updates and applying service pack.
• Worked on Database Encryption (TDE) with SSL for safeguard between application and database instance.

SQL Server Database Administrator

Confidential, Huston TX

Responsibilities:

• Installed and Upgraded from SQL Server 2012 to SQL Server 2014 on Various Production Servers.
• Migrated from MS Access and Oracle to SQL Server.
• Implemented major changes to the Microsoft SQL Server databases for overall performance enhancement and troubleshot.
• Designed new database maintenance plans, DTS/SSIS (ETL) programs and did performance tuning of the existing processes.
• Helped and worked with others to redesign retail-banking applications such as mortgage loan, customer support app, online banking etc.
• Involved in resolving Lock and Deadlock and Index Optimization.
• Tuning queries, which are running slow using Profiler and Statistics IO by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS), advanced SSIS for data transfer and loading.
• Created Scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Replication, Log-shipping, Point-In-Time disaster plan and recovery.

Database Administrator

Confidential, Vienna, VA

Responsibilities:

• Installed, Configured and Maintain Fail-Over Clustering using SQL Server 2012/2008R2/2008 for Windows 2008 R2 environment.
• Installed Configured and Maintain Database Mirroring using automatic fail-over option in, High Safety/High Performance Always On technology on MS SQL 2012, 2014.
• Participated in migration and consolidation of SQL Server databases.
• Assisted in operational activities of database platforms.
• Implemented performance tuning and assisted in system troubleshooting.
• Provided technical support for all components of major databases.
• Conducted data modeling and designed relational databases.
• Maintained and managed DBCC checks and resolved data corruption issues.
• Created database schema objects including indexes and views.
• Monitored SQL Server performance and administered SSIS dataflow transformations.
• Responsible for disaster recovery (DR) and high availability (HA) solutions.
• Strong communication and interpersonal skills. Ability to meet deadlines and set priorities.
• Database security Administration. Protecting database integrity. Managing access controls and adequate segregation of duty, user access management i.e. creating and granting user access and roles.

Data and Resource Analyst

Confidential, Winchester, VA

Responsibilities:

• Monitoring performance, troubleshooting customer or end user issues analyzed and resolved.
• Day to day operation maintenance, worked with SLA (Service Level Agreement) for hosting databases and providing services.
• Accomplishes accounting human resource objectives by recruiting, selecting, orienting, training, assigning, scheduling, coaching, counseling, and disciplining employees.
• Communicating job expectations; planning, monitoring, appraising, and reviewing job contributions, planning and reviewing compensation actions, enforcing policies and procedures.
• Achieves accounting operational objectives by contributing accounting information and recommendations to strategic plans and reviews, preparing and completing action plans, implementing production, productivity, quality, and customer-service standards, resolving problems.
• Completing audits, identifying trends, determining system improvements, implementing change.
• Confirms financial status by monitoring revenue and expenses, coordinating the collection, consolidation, and evaluation of financial data, preparing special reports.