SUMMARY

• Over 8 years of experience as MS SQL Database Administrator and programmer. Responsibilities include daily SQL optimization, Performance tuning, production support, maintenance review, Disaster recovery planning and ensuring 24x7 supports.
• Excellent experience working on different versions of SQL server like SQL 7, 2005, 2008 and 2012.
• Expert in the areas of MS SQL Server installation, Configuration, Server upgrade, Database design and normalization, Performance tuning, Security administration, Backup and recovery, Disaster recovery techniques such as mirroring, log shipping and clusters.
• Strong T - SQL programming skills with real time experience in customizing applications by creating and managing database objects like tables, triggers, views, stored procedures, functions and indexes.
• Securing Organization’s Data by implementing least privilege, choosing appropriate authentication modes, data encryption, defining need specific server/database/application roles and granting permissions at granular level as required.
• Ensuring high availability of databases for smooth running of the business by implementing high availability solutions like Database Mirroring, Log shipping and failover Clusters depending upon the criticality of the applications and as per Organizational requirement.
• Maintain Data reliability to proactively avoid Data corruption and unexpected performance issues by implementing Maintenance plans and performing Database Consistency Checks that ensures data integrity and consistency.
• Plan and implement Disaster Recovery strategies with effective Backup and Recovery policies, setting up replication, documenting the recovery process and a tested plan to recover the databases and users as quickly as possible.
• Monitor database server resources and provide recommendations on hardware/software upgrade to increase server performance. Monitor databases and resolve any blocking issues. Identify slow running queries and perform performance tuning by examining the execution plans and creating missing indexes to boost the query performance.
• Ability to Build and maintain complex SQL queries for data analysis and data extract. Strong experience working with stored procedures, database tuning methodologies, naming conventions, extraction, transformation and query methodologies.
• Motivated to take independent responsibility as well as to contribute to be a productive team member. Strong Team building and mentoring skills.
• Strong Logical & Analytical Reasoning Skills, Management skills, Excellent Communication with good Listening, Presentation and Intrapersonal Skills

TECHNICAL SKILLS

Databases: SQL Server 7/2000/2005/2008/2012 , Oracle, Sybase, MS Access

Tools: Management studio, Idera SQL Safe, Quest Lite speed, Red gate SQL backup Pro, Compliance Manager, Idera Diagnostic Manager, Erwin Data Modeler, DB Artisan, Ramco ERP.

Reporting: Crystal Reports, Microsoft SQL Server Reporting Services

ETL Tools: MS Data Transformation services, SQL Server Integration Services

Programming Skills: T-SQL, Java, C, C++, HTML

Modeling Tool: Erwin 4.1, MS Visio.

Operating Systems: Windows 2005,2008 R2

Scheduling Tool: Windows scheduler, SQL Server Agent

Business Tools: Word, Excel, PowerPoint, Access, Outlook

PROFESSIONAL EXPERIENCE

Confidential, Woodland Hills, CA

Database Administrator

Responsibilities:

• Design databases and apply normalization to minimize data redundancy
• Support and co-ordinate merging DBA support across all newly acquired companies
• Manage SQL Server security by granting appropriate server and databases roles/permissions and by having frequent security checks for inappropriate access
• Install and configure SQL server 2012. Analyze results of upgrade advisor and perform database upgrades from /2012
• Perform cleansing of data loaded from legacy systems using data conversion scripts and produce clean formatted data which can be loaded into production system.
• Setup monitoring jobs for monitoring Security changes, Administrative activities, Login failures, and DDL changes. Weekly, quarterly and daily reports are in place for review
• Automation of frequent refresh requests are taken care of by creating SQL jobs that copy the backup from production, backup roles and users from development database, perform refresh and reapply the roles and users on to development.
• Check alerts from SQL Log and work with Server team to fix any I/O or operating system issues. Help troubleshoot error and perform Root Cause Analysis
• Work towards achieving 100% results with Service Level Agreements by handling requests as per severity and getting back to the users well before SLA with resolution
• Ensure daily and weekly Database maintenance jobs succeed. Also take care of other application related jobs that are critical for the application
• Help application team identify the blocking process by collecting information on block processes after the fact using scripts querying DMVs
• Deploy SSIS packages on to production server and configure configuration files
• Document and gather information on the SQL server inventory list using MAP tool and help in decommissioning the servers that are no longer used in co-ordination with business owners.
• Server consolidation also helped in minimizing licenses required
• Ensure standard backup policies are implemented across all servers depending upon the application criticality. Make sure we have backup cleanup tasks are in place
• Plan, test and apply SQL patches on SQL servers to make sure we are up to date
• Help improve performance of queries by analyzing the execution plans, monitoring resource utilization and Database engine tuning tool to identify indexes/statistics that can help in performance tuning
• Gather service account information and document the same for all locations

Environment: Windows 2008, SQL Server 2005, SQL Server 2008, SQL Server 2012, SSRS, SSIS, SSAS, Red gate SQL backup Pro, Idera Diagnostic Manager, ITSM ticketing tool, MS Outlook, MS Word, MS Excel, MS Project, MS PowerPoint, SSRS, SSIS,SSAS

Confidential - Sacramento, CA

SQL DBA

Responsibilities:

• Installed and maintained MS SQL Server 2005 on Windows 2003 Server. Worked on SQL Server 2003failover clustering which is built on top of a Windows 2003 server cluster.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQLServer.
• Designed and developed SSISpackages using different control flow tasks, data flow task and data transformations
• Configuring, tuning and optimizing SQL Server 2005.
• Responsible for Stored Procedures optimization, Performance tuning & index tuning.
• Administrator tasks like managing users, roles and permissions. Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.
• Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing, Resource Governor and Merge statement in T-SQL.
• Performed data partitioning for efficient management of database tables and indexes
• Involved in complete database design including conceptual, logical and physical models.
• Experienced in SQL server PowerShell provider and central management server.
• Participated in the designing and development of software using agile development practices.
• Providing support for storage operations for EMCDatadomain, Net backup and other storage products. Based on the EMC requirement, updated the drivers (HBA etc.)/patches (Operating System) on all systems involved in the data migration.
• Implemented Tivoli Alerting for the SAN Infrastructure devices to alert the command Center and worked closely with Tivoli team to create log adapters and carefully planned out the severity levels.
• Creating DTS Packages for data import/export, scrubbing and scheduled jobs for backups.
• Managing local and remote databases from within IIS (Internet Information Services) Manager.
• Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Maintained high availability of databases using Database Mirroring and Log Shipping.
• Used third party tool, Lite Speed, Red Gate to speed up backup operations.
• Created Complex reports using SS Reporting services.
• Created and maintained logical/physical data structures.
• Creating views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation and data extraction.
• Created the reports using Business Objects functionality's like Queries, Sub queries, Slice and Dice, Drilldown, Cross Tab, Master Detail and Formulae's etc.

Environment: Windows 2008, MS SQL Server 2005, UNIX, EMC Data domain, SAN, T-SQL, Visual Studio, Crystal Reports 8.5, Business Objects 6.1b, OLTP, SQL Loader, IIS, Lite Speed, MS Access, DTS, BCP, SSIS, SSAS, SSRS, SQL Profiler.

Confidential, MAINE

Database Consultant

Responsibilities:

• Maintain SQL Server Production databases and ensure high availability
• Analyze slow running queries across environments and find the root cause for the same and resolve by introducing missing indexes, partitioning tables and placing them in different file groups on different drives to improve performance
• Attend requirement gathering meetings along with application team and understand the requirement or change to be incorporated in the existing
• Database objects design and normalization, review and implementation
• Support change projects where database objects are designed, reviewed and created as per change requirement and ER Diagrams produced using Erwin tool
• Interact with the client, understand and gather requirement, identify the DB objects to be modified and new objects to be created
• Manage space on database servers by proactively forecasting the DB growth
• Back databases before change implementation and ensure rollback capability
• Perform ETL operations with the help of SSIS packages for the initial setup of DBs
• Restore development and staging databases to help development team work on the current version of the database to avoid errors during production move up
• Create roles and grant permissions to users upon proper approval from business
• Ensure the change process is followed religiously and suggest changes required
• Document the changes made to the database objects and update ER diagrams
• Provided secondary DBA support for Sybase and Oracle databases
• Attend weekly change control meetings and participate in discussions

Environment: Windows 2003, Windows 2008, SQL Server 2005, SQL Server 2008, Sybase 9, MS Outlook, MS Word, MS Excel, MS Project, MS PowerPoint, Westar.

Confidential

Database Intern

Responsibilities:

• Installation and configuration of SQLServer 2000/7.0 on Window 2000/NT OS.
• Managing of database objects like Tables, views, stored procedures, indexes etc.
• Written complex stored procedures and functions according to business requirements.
• Implementing Backups and restoring when necessary.
• Creation and management of Database maintenance plan for various database consistency checks.
• Extensively working on performance issues like update statistics, Auto Stats.
• Experience in SQL Server Analysis Services (SSAS) for designing OLAP Cubes.
• Creating monthly transaction report for all sections. Developing of Multi-Lingual Reports using Crystal Reports.
• Designed and Implemented Reports using Business Objects Full Client.
• Reports were developed using Crystal Reports utility.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Involved in planning, designing, configuring and implementing SAN fabric.
• Worked on monitoring and tuning of SQL scripts using UNIX. Created upgrade scripts for production database and supported it.
• Managing of users including creation/alteration, grant of system/db. Roles and permission on various database objects.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Develop documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Environment: SQL Server7.0/ 2000, Enterprise Manager, Windows 2000, SQL Profiler, DTS, Unix, Perl, Business Objects, T -SQL, ERWIN Data Modeler, SAN, DTS, SSAS, SSRS, SSIS, Crystal Reports.