SUMMARY

• 5+ years in - depth experience managing multiple MS SQL Server 2005/2008/2008 r2, 2012 databases in development testing, and production environments.
• Logical and physical planning of relational databases; manage internal databases from planning and testing stages through implementation and support.
• Hands on installation and configuration experience with Database software, service packs and complimentary third party tools.
• Supporting, consolidating, and maintaining SQL Server 2005/2008/2008 r2/2012 databases while ensuring their performance, high availability and internal/external security.
• Proficiency in data modeling, database optimization, relational database schemas.
• Expertise in creating database objects and structures including tables, indexes, views, snapshots, stored procedures, triggers, and functions.
• Controlling access permissions and privileges.
• Developing, testing, implementing and managing backup and recovery plans.
• Extensive experience on high availability tools including: Log shipping, database mirroring, and replication.
• Expertise in automating maintenance and monitoring jobs in SQL job agent.
• Working knowledge on performance tuning using native tools like profiler, performance monitor, activity monitor, event viewer, index tuning, data base tuning advisor (DTA), services and protocols and configuration manager for performance analysis and query optimization.
• Experience in using dynamic management views (DMV) and dynamic management functions (DMF) of Tables, Performance Monitor, and SQL Server Profiler for finding out long running queries
• Experience in Extract, Transform and Load (ETL) data from different data Sources using MS SQL Integration Service (SSIS), BCP and BULK INSERT.
• Developing adhoc reports using MS SQL Reporting Service (SSRS).
• Experience in Migrating MS SQL server 2005 packages to MS SQL server 2008/2008 r2
• Writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata).
• Excellent communication, coordination, presentation and analytical skills.
• Personnel strengths includes self-motivation, commitment, integrity, enthusiasm, pride in work, excellent attendance, punctuality, and hardworking, while maintaining the highest efficiency possible.
• Possession of strong interpersonal skills, excellent communication skills and ability to follow directions, dedicated and focused to complete multiple tasks, works well independently & in groups as well.

TECHNICAL SKILLS

Database: MS SQL Server 2005/2008/2008 R2/2012, Oracle 11g, & MS Access

Languages: XML, HTML, T-SQL, PL/SQL, & C#

Web Technologies: MS SharePoint 2013, Dreamweaver

Intelligence Tools: SSMS, SSIS, SSRS, Import & Export, SQL Server API’s, Crystal Reports, ERwin

Office Automation: MS Office 03/07/10, Visio, Project, Outlook

Operating Systems: Windows NT 4.0/2000, 2003, 2008, XP, Vista, Windows 7

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Senior Database Specialist

Responsibilities:

• Processed the acquisition, evaluation, transforming, merging and filtering of electronic and manual data from relational database systems that are associated with newly terminated defined benefit pension plans
• Created new databases, manage database security, enroll and map users.
• Created and optimize objects in the database, e.g. Tables, Views, indexes, stored procedures, functions, and Triggers.
• Administered, maintain, develop and implement policies and procedures for ensuring security and integrity of the company database.
• Scheduled and automate backups and implementing recovery strategies.
• Configured and monitor database Mirroring and Log Shipping as high availability strategy.
• Experience in solving Real Time issues withIndex fragmentation, DBCC checks, Query Tuning, ErrorandEvent Handling.
• Developed reports using SSRS, Crystal Reports, MS Excel spreadsheets and Access.
• Developed automated procedures to produce client data files on schedule using MS Integration Services (SSIS).
• Extracted, Transformed and Loaded (ETL) data from different data Sources using MS Excel, MS Access, and Oracle 11g database system.
• Developed database documentation, including data standards, procedures and definitions for the data dictionary (Metadata).
• Experienced in SDLC life cycle fordesign, developmentandstagingphases of the projects with support of Data-Flow, Process Models, E-R Diagrams.
• Worked with development teams with data cleansing, migration and loading, in addition, to supporting development teams with reviewing, building, testing and maintaining database structures and SQL scripts Archive files using Data warehouse utility, Archive Utility, and retrieval of pension data files.
• Assisted Auditors, Actuaries, and Pension analysts on ad-hoc data and database related requests and reports.
• Enhanced end users understanding of the database systems by conducting pre-implementation workshops, delivering group and individual training sessions and create user friendly training
• Worked on documentation all reports, procedures and archive with document writer as necessary.

Confidential, Sterling, VA

MS SQL Server DBA

Responsibilities:

• Installed and configured database software and corresponding tools
• Responsible for logical and physical planning of the databases capacity planning.
• Developed, Implemented and Administered policies and procedures for ensuring security and integrity of the company’s database.
• Scheduled and automated full/differential/ transactional backups and implementing recovery strategies
• Implemented database mirroring with automatic failover and log shipping for high availability plans
• Utilized tools like Database tuning advisor, SQL profiler, Performance monitor, Activity monitor, Event viewer for performance analysis.
• Strong experience in Performance Tuning including Updating Statistics, Re-Indexing Query Optimization
• Migration of data from MS SQL 2005 and other flat files to MS SQL 2008.
• Wrote simple and complex queries with TSQL to retrieve as well as process database objects in Ms SQL 2005/2008 server instance.
• Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability. .
• Run scripts daily to check database growth & systems performance.
• Profiled and tuned servers on a monthly basis to ensure fast queries and reports.
• Worked on defining data repository, data dictionaries and warehousing requirements.
• Scheduled and monitored SQL agent jobs.
• Optimized database objects, e.g. Tables. Views, stored procedures, functions, CLR code and Triggers.
• Analyzed reports of data duplicates or other errors to provide ongoing appropriate team members communication and monthly or daily data reports using SSRS and Crystal Reports.
• Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), stored procedures

Confidential, Washington, DC

MS SQL Server DBA/Report developer

Responsibilities:

• Responsible for SQL server logical and physical database design, implementation, and maintenance.
• Created new databases, managed database security, enrolled and map users.
• Created Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors, Temp tables and Dynamic SQL queries.
• Experienced in Normalization, Database design, Performance Analysis and Production Support.
• Scheduled and automated maintenance plans using SQL Server job agent.
• Designed, implemented and managed database maintenance and disaster recovery plans including full /differential /transactional backup and recovery procedures.
• Implemented and managed transactional log shipping, SQL server Mirroring (Synchronous/ Asynchronous).
• Extensively used the native tools like Index tuning wizard, Database tuning advisor, SQL profiler, Performance monitor, Activity monitor, Event viewer for performance analysis.
• Implemented database refresh using full export for table level and full database defragmentation, resulting in improved performance and effective space management.
• Analyzed execution plans and index management for better Query Optimization.
• Configured SMTP Server for Database Mail setup and received Alerts.
• Developed reports using SQL Server Reporting Services (SSRS).
• Data Migrated to and from various sources using SQL Server Integration Services (SSIS).
• Worked with a team of business analysts, data architects, application developers, and testers.
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.