Senior SQL Server Database Administrator Resume

CAREER OBJECTIVE:

Seeking a Database Administrator/Developer or Business/Data Systems Analyst position in a company where I can use my experience and education to help the company meet and surpass its goals.

SUMMARY:

12+ years of professional IT experience, including 8+ years of SQL Server DBA and 4 years of Database Developer and Business/Data System Analyst experience.
A proactive and team player DBA with detail orientation, installation, configuration, and troubleshooting experience in different Microsoft SQL Servers (2005/2008/R2/2012/2014), different Microsoft Server operating Systems ( 2000/2003/2008/2012 ) AD (Active Directory), data modeling including gathering and analyzing business requirements, solid working experience in managing medium to large databases in 24/7 environment including backup/recovery, developing and managing reports using SQL Reporting Services (SSRS), performance tuning, developing T - SQL queries, stored procedures, triggers, functions, and constraints.
I managed database in Test, Development and Production environments.

SELECTED TECHNICAL SKILLS:

Databases: MS-SQL Server (2005, 2008/R2, 2012, 2014), MySQL, MS Access, Oracle

Languages: T-SQL, PL/SQL, Java (6+ years), C, C++, C# (5+years)

Web: J2EE (RMI, JDBC, Servlets, JSP), JavaScript, HTML, ASP.NET

Web Application Server: Apache Tomcat

Tools: MS Visual Studio (2005, 2008), NetBeans (6.71, 6.8), Eclipse, Jira, Rational Rose, MS Visio.

Platforms: Windows 98/2000/2003/ XP/7/8/12.

PROFESSIONAL EXPERIENCE:

Senior SQL Server Database Administrator

Confidential

Responsibilities:

Installed, Configured, and Managed SQL Server 2000/2005/2008/2012/2014 in development, test, and production environment.
Collected, documented and analyzed business requirements and functional specifications using waterfall and agile methodologies.
Organized, allocated, scheduled and tracked tasks using Jira . built interactive wireframes & prototypes.
Installed and Configured Microsoft Server Operating Systems: Windows Server 2000/2003/2008/2012
Configured and monitored the High availability and Disaster recovery solutions on SQL Server (Failover Clustering, Alwayson, Database Mirroring, Log-Shipping, and Replication Technologies).
Created Tables, Views, Triggers, Dynamic Stored Procedures, User Defined Functions and other T-SQL (DDL, DML) statements for various applications.
Generated Reports using SSRS (SQL Server Reporting Services)
Handled Database Backup and Restore.
Created, maintained, and executed scheduled jobs, data extracts, data refreshes, data loads and data replication.
Developed different maintenance plans for database monitoring.
Created and managed database user accounts and the corresponding roles.
Provided pro-active management of systems to prevent unnecessary system downtime.
Worked with various project teams simultaneously and helped them meet their project deadlines.

Environment: MS SQL Server 2012/2008/2005/2014 , Windows Server 2012/2008/2003 , SQL Profiler, SSIS, SSRS, SSAS, T-SQL, Jira, Microsoft Visual Studio 2008.

SQL Server Database Developer and Business System Analyst

Confidential

Responsibilities:

Created a relational database.
Developed and documented conceptual/logical/physical database design.
Constructed entity relationship diagram (ERD) for data modeling.
Developed database object as T-SQL, stored procedures, user defined functions, triggers, views, complicated queries, indexing, etc
Collected, documented and analyzed business requirements and functional specifications using waterfall and agile methodologies.
Organized, allocated, scheduled and tracked tasks using Jira .
Elicited requirements using interviews, JAD sessions, documents and workflow analysis, business process descriptions.
Managed sub-teams working on different projects.
Organized test plan documents and executed testing.
Produced Use Case models based on UML methodology & business process flow diagrams.
Managed all types of change requests, defects, enhancements, issues and documentation changes.
Worked with various project teams simultaneously and helped them meet their project deadlines.

Environment: MS SQL Server 2008/2005, Windows Server 2000/ 2003/2008 , Jira, Rational Rose, MS Visio, MS Office (Word, Excel, Access), Java, JavaScript, Microsoft Visual Studio 2005/2008.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship