Senior MS Database Administrator Resume

SUMMARY:

Microsoft Certified Professional with over 4 years of extensive experience in Administering and Managing of multiple MS SQL Server Databases in Production and non - Production environments.
Primarily concerned with managing the SQL Server relational database management systems hosted on Microsoft Window 2003/ 2008/ 2008 R2/ 2012 / 2016 servers running on Physical and Virtual hardware platforms in a 24 x 7 environment Using SQL native tools and third-party products.
Experience in installing and configuring SQL Server, applying patches and fixes.
Solid Experience monitoring, troubleshooting, and performance optimization related issues.
Experience in creating Tables, Views, Indexes, Store Procedure, and Triggers.
Experience in Administering SQL Server security by creating user logins with appropriate roles. Backup, restores, recovery models, database shrink operations Clustering, Data mirroring, and Replication.
Strong knowledge in setting up and managing database security by creating new users, roles, profiles, and provide required user privileges in development, test, training and production environments.
A good excellent analytical, problem-solving, communication and interpersonal skills with the ability to interact with people at all levels and can work as part of a team as well as independently.

PROFESSIONAL EXPERIENCE:

Confidential

Senior MS Database Administrator

Responsibilities:

Installed, Configured and maintained Microsoft SQL Server 2008 R2 / 2012
Configured Failover Clustering features in SQL Server 2012 and AlwaysOn Availability Groups
Tested and Upgraded SQL Server (in development, testing and production environment) from
2008/R2 to 2012 using Side-by Side and In-Place upgrade methods
Used upgrade advisor to analyze and detect any issues, and used upgrade advisor reports
Performed patching - applied SPs and Hot Fixes on SQL 2008 R2/2012
Used the SQL Server Configuration Manager to configure services, network protocols, and network

Confidential

MS Database Administrator

Responsibilities:

I Maintained clients' records and made various databases accessible to users.
I Used SQL Indexes for improving query performance.
I lowered storage and maintenance cost.
I Used optimization tools such as SQL Profiler, Dynamic Management Views (DMVs) and Windows

Confidential

Junior Database Administrator

Responsibilities:

My general responsibilities included Administering, maintaining all existing SQL servers across Enterprise.
I Developed and implement policies and procedures for ensuring security and integrity of the Company database.
I was Responsible for logical and physical planning of the databases capacity planning.
I Installed and configured of database software and corresponding tools.
I developed, implement and administer policies and procedures for ensuring security and integrity.
I Implemented data models, database designs, data access, and table maintenance codes.
Building, testing and maintaining database structures and SQL scripts.
I Reviewed and optimized SQL queries, stored procedures, views and triggers from other

Confidential

Business Analyst

Responsibilities:

Performed risk assessment functions including claim determinations and membership analysis to set appropriate premiums.
Accurately developed pre-sale and renewal rates using demographic data, benefit plan design, rating tools and underwriting judgments.
Provided underwriting for new business quotes, renewals, key accounts, and specialized functions.
Worked with Actuarial, Underwriting, IT and Product teams to gather large amounts of data from different sources, analyze and design, develop, unit test, and implement understanding of current and emerging IT products, validate the output quotes services to insure quality and accuracy.
Demonstrated proficiency at requirements planning and monitoring, requirements elicitation, requirements documentation, and providing support from solution design, test phases, implementation through to post-implementation.