SUMMARY:

• 13+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2016,SQL Server 2014,SQL Server 2012, SQL Server 2008 R2, 2008 and 2005.
• Ensure database systems operate efficiently and securely.
• Skilled in designing and implementing complete life cycle client servers and database applications with various development tools and languages.
• Manage internal databases, from planning and testing stages through implementation and support.
• In - depth understanding of security and backup procedures to ensure database integrity. Background in developing backup and disaster recovery plans for nationwide offices.
• Superior communication, presentation, analytical and problem solving skill. Work well with all levels of business.
• Very well versed in translating Business requirements to Technology development/administration/maintenance.
• Well experienced in setting goals and priorities for technology to reflect business needs and rules. I have been involved all facets of Technology management and Business Liaison.

TECHNICAL SKILLS:

Databases: MSSQL 2000, 2005, 2008, 2012, 2014, 2016 & Oracle 8i/10g

Operating Systems: Win NT, XP, Win-7, Win-8, Win 8.1

Servers: Windows 2003, 2008, 2012

Web Server: IIS 6.0, 7.0

Languages: Windows PowerShell

Web Technologies (Server Side): SharePoint Administration 2010

Monitoring Tool: System Center Orchestrator 2012

Service Tool: Siebel Helpdesk, TFS Desk

Source code Management: Team Foundation Server\Visual Studio Online (Cloud Collaboration Tool for Teams)

Automation Tool: System Center Operation manager 2012

Network Storage: NetApp

PROFESSIONAL EXPERIENCE:

Confidential, California

Sr. Database Administrator

Responsibilities:

• Data Requirement Analysis, Data Modeling and Data Architecture for the project.
• Evaluate and recommend new database software, utilities, and tools. Provide Subject Matter Expert guidance on tool related issues.
• Creating Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS Packages.
• System monitor to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance
• Index tuning wizard to redesign and created the indexes for better performance.
• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Updating with latest service packs and security patches using PowerShell & Batch Scripts
• Rebuilding / monitoring the indexes at regular intervals for better performance.
• Deployed the DB Builds for various Environments like QA, Integration, UAT and Productions Environments.

Environment: MS SQL Server 2012 & 2016, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS), PowerShell, Batch Scripting, Visual Studio Team Services

Confidential, Pittsburgh, PA

Technical Project Manager

Responsibilities:

• Migrated SQL server 2008 to SQL Server 2012 in Windows Server 2012 Enterprise Edition.
• Installed and administered Eight-Node cluster Active/Passive on Windows Server 2012 Enterprise Edition on SAN environment.
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Rebuilding / monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Performed and deployed Builds for various Environments like QA, Integration, UAT and Productions Environments.

Environment: MS SQL Server 2008, MS SQL Server 2012 Visual Studio Team Services & Visual Studio Online

Confidential, Pleasanton, CA

Sr. SQL Server DBA

Responsibilities:

• Very well versed with Performance and Tuning of SQL Servers
• Works closely with other Customer Services Technical staff, Architects, Senior Developers, Testers and Performance Engineering locally and remotely, to develop internal frameworks to support SQL Server database access.
• Evaluate and monitor databases to resolve performance issues, minimize data redundancy and support capacity planning.
• Maintain MS SQL Server databases in the development and test environments. Create/alter databases; replicate databases; perform day-to-day database administration.
• Design, implement and support database backup and recovery procedures.
• Develop data requirements for application/inter-application test plans and test scenarios; verify test results. Coordinate testing activities for appropriate applications system development team(s) with database Administrators as required
• Assist with creating and maintaining documentation standards, coach others on developing high quality documentation.
• Perform problem determination (root cause analysis), and document the source of problems and their resolution. Aid customers and other staff members in resolving errors resulting from the use of applications. Recognize and analyze trends in errors so as to identify and install long term solutions to problems.
• Manage multiple tasks and projects to schedule, ensuring requirements are met. Report on progress weekly and measure against goals/initiatives to management for meeting project objectives.
• Implemented Change Data Capture (CDC) to the table-level on database for which CDC is enabled. Having experience from SQL Server 2005 to SQL server 2012

Environment: MS SQL Server 2005, 2008, 2012 & 2014, Windows 2012 Server

Confidential, Redmond, WA

Sr.Database Administrator

Responsibilities:

• Database Architect cum project lead for several projects. Senior Advisor for several other projects in the company.
• Data Requirement Analysis, Data Modeling and Data Architecture for Several projects and for several clients
• Managed over 20 projects. Technical lead for the larger projects. Advisor for smaller projects.
• Monitored and identified several performance bottlenecks, and reconfigured the SQL servers to improve performance.
• Reconfigured several windows 2008 servers to become a database server machines. Installed and configured several SQL Server 2008 instances. Configured linked servers

Environment: MS SQL Server 2008, 2012, 2014, Windows 2008 R2 Server, Windows 2012 Server, SCOM 2012R2, SSIS, SSRS

Confidential, Seattle, WA

Database Administrator

Responsibilities:

• Using PowerShell installed SQL Server 2008 and 2012
• Setup the Always On Availability group in SQL Server 2012 clustered environments
• Setup database mirroring on multiple servers with manual failover.
• Migrated databases from one server to other on same versions of SQL Servers as well as different versions of SQL Servers.
• Setup maintenance plans on 325 SQL Servers on Dev, QA and Production Servers.
• Configured and used SCOM (System Centre Operations Manager), to monitor all SQL Servers

Environment: MS SQL Server 2000 - 2012, Windows 2003 Server, Windows 2008 R2 Server, Windows 2012 Server, SCOM 2007R2,SCOM 2012R2,SSIS and SSRS

Confidential

Database Administrator

Responsibilities:

• Provided production/development/QA support for business and mission critical applications.
• Implemented, configured, and administered replication for MS SQL 2005 Servers.
• Performed development and production upgrades from system 2005 to 2008 versions.
• Responsible for performance/tuning of all the instances.
• Designed SQL Server monitoring product to monitor multiple SQL Server tasks on 2005 and 2008 SQL Servers.
• Responsible to assign proper login/user access on instance/database level.
• Upgraded multiple 2005 databases to 2008 R2

Environment: SQL Server 2005 - 2008, Windows 2000/2003/2008, SSIS and SSRS

Confidential

Jr. Database Administrator

Responsibilities:

• Provided 24x7 production/development supports for several third party and in-house applications, which utilized multiple MS SQL Server databases.
• Developed monitoring module to monitor all SQL Servers on the Enterprise level Configured log shipping on 2000, 2005.
• Installed integration, analysis, reporting and notification services on SQL Server 2005.
• Managed and administered large volume SQL server databases ranging from 150 GB and up
• Monitored, troubleshoot and recovered databases all versions of SQL Servers.
• Configured and implement HA cluster, replication, mirroring and log shipping for SQL servers
• Developed, implemented, configured and maintained operational procedures and programs, including disaster recovery, system security.
• Installed, upgraded, configured and tuned 70 plus SQL Servers for optimal performance.
• Performed application/data migrations for all SQL Servers databases.

Environment: SQL Server 2000 - 2005, Windows 2000/2003, SSIS and SSRS

Confidential

Senior Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Designed several universes and used various methods to optimize queries on database, universe and reporting level.
• Worked towards optimal development of universes by removing loops through the use of aliases and contexts.
• Exported the universes to the Repository to make resources available to the users.
• Created reports for various Portfolios using the Universes as the main data Providers.
• Applied drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
• Created Business Objects Repository while building Business Objects solution.
• Published and scheduled Business Objects Reports to users using Scheduler.
• Migrating Business Objects 6.5.1 version reports to new version XIR2.
• Imported existing users, groups, categories, WebI documents, connections, universes and restrictions to BO XI environment using Import Wizard.
• Created reports using Desktop Intelligence and Web Intelligence in BO XI R2 environment.

Environment: Business Objects 6.5.1, BO XI, Oracle 10g, SQL Server 2000

Confidential

Senior Developer

Responsibilities:

• Information gathering - interacted with the end user to understand the requirement and business logic
• Analysed the existing OLTP system and designed and managed universes based on the Business Requirements
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies
• Created reports using Business Objects functionality like slice and dice drill down, cross tab, master detail tables and formulas, etc.
• Created complex reports by linking data from multiple data providers, using free hand SQL and functionalities like Combined Queries.
• Working on the SQL tuning and optimization of the Business Objects reports.
• Worked extensively on Web Intelligence for any new requests and performance issues.
• Involved in installing Web Intelligence, creating users, user groups and categories
• Created Web Intelligence documents and published them to corporate documents.
• Extensive testing and migrating the reports or objects from development to Production system

Environment: Business Objects 6.5.1, Oracle 10g, SQL Server 2000, Windows 2000

Confidential

Developer

Responsibilities:

• Analysis of Business Objects environment, Universes, Reports.
• Add more groups and change the profile of users via supervisor.
• Developed Universe using Designer module in Business Objects.
• Developed and created classes with Dimension, Detail & Measure Objects and specified the hierarchies.

Environment: Business Objects 6.5, Web Intelligence, Oracle.