profile

Accomplished experience as an MS SQL Server DBA responsible for effectively operating and managing various system architectures and database servers that require extensive use of analytical, technical and organizational skills. Efficiency oriented, and detailed conscious when working on installing, configuring and optimizing all technical specifications and applications to ensure a successful technical environment. Independent with the ability to work within time constraints. Powerful communication skills and the established capability to develop positive working relationships with all contacts. Foremost personal traits are commitment, collaboration and professionalism

TECHSKILLS:

• MS-SQL SERVER 2000, 2005, 2008, Oracle 8 and 9i, 11G,
• MS BIG DATA Front end applications: VB4,VB5, VB6, VBA, VB.NET and light experience with Java Operating Systems: Windows and UNIX
• Additional Tools and Applications: Idera, 3-PAR RM, Autosys

Confidential

Senior Database Administrator

• Designed and Implemented Disaster Recovery strategy plan for all business crucial SQL Server databases by utilizing backup/recovery methodology as well as DB MIRROR.
• Used DMVs and Performance Counters to identify bottlenecks in the system performance to further troubleshoot, fix and stabilize our SQL Environment.
• Migrated data from different environments and SQL Versions.
• Created SSIS packages to import and export data across databases
• Implemented/Setup Transactional and Merge Replication between servers in different locations.
• Identified and resolved bottlenecks in the system that were caused by poor written query design patterns. Tuned indexes while working closely with developers.
• Created stored procedures, triggers and utilized table portioning.
• Established and maintained policies, standard operating procedures, and associated documentation for user interaction with the database environment.
• Supported and helped users write the most efficient T-SQL code, stored procedures and triggers.
• Installed SQL Servers 2005 and SQL Servers 2008 in Development, QA and Production environments.
• Planned the strategy to utilize MS Big Data in our SQL Environment which would utilize SQL SERVER 2012 in the upcoming year.
• Installed patches, upgrades to Windows Server 2003, 2008.
• Utilized Idera Monitoring Performance tools to monitor SQL Server Environment.
• Set up traces and Profiler to troubleshoot performance issues.
• Supported SQL Server Clustered Environment as well as DB Mirror in Development, QA and Production environments.
• Involved in data capacity planning and strategy when engaging with Application owners and users.
• Level 2 support of the SQL Server Environment.

Confidential

Senior Database Administrator

• Installed SQL Servers 2005 and SQL Servers 2008 in Development, QA and Production environments.
• Installed and supported SQL Server Cluster, Transactional Replication and DB Mirror in Development, QA and Production environments.
• Supported Oracle 11g Production Environment as an Oracle backup DBA.
• Utilized cold and hot backup as well as RMAN.
• Supported Oracle RAC environment.
• Consolidated data and migrated servers from SQL Server 2005 to SQL Server to 2008 with the goal of decommissioning servers.
• Implemented/Setup Transactional and Merge Replication between servers in different locations.
• Assisted developers in writing the most sufficient T-SQL code, stored procedures and triggers.
• Implemented Disaster Recovery strategy, by offering best solutions according to Applications and Business needs.
• Provided and implemented best SQL Server high availability solutions.
• Utilized SSIS packages to transfer data between servers.

Confidential

MS SQL Solution Engineer/Database Administrator

• Installed SQL Servers 2005 and SQL Servers 2008 in Development, QA and Production environments.
• Installed and supported SQL Server Cluster in Development, QA and Production environments.
• Consolidated data and migrated servers with the goal to decommission servers.
• Successfully migrated databases from SQL Server 2000 to SQL Server 2005 and SQL Server 2008.
• Worked closely with various business application teams to solve different back-end issues that would impact production.
• Set up and supported transactional and merge replication
• Offered solution and helped implement table partitioning on SQL SERVER 2005 to make it more efficient and better resolution for data warehousing and reporting purposes.
• Helped business team to load data faster using either BCP utility or BULK INSERT
• Worked with business teams on making better design of the applications, create indexes, breaking down stored procedures to make it run much faster. Worked with business teams to bring CPU utilization down from 90 to under40 by applying various database tuning methods.
• Worked with Oracle as a DBA Backup. Installed and configured Oracle.
• Monitored Oracle Production server. Managed tablespaces, grated users access, and monitored backup and maintenance plans.
• Created VB6 application that retrieved data associated with all of our SQL Server Environment and Infrastructure, Including SQL Server Name, Host Name IP Address, Instance Name, List of Databases and Size
• Utilized SSIS packages to import and export data
• Level 3 support

Confidential

MS SQL Database Administrator

Supported Production, Staging and Development SQL Server environments that were shared by multiple business critical applications.

Installed SQL Server Cluster for both Staging and Production environments. Both environments were configured as Active-Passive.

Consolidated SQL Server databases to shared environments.

Installed and configured SQL Server 2008 for our Business Intelligence data warehouse.

Migrated several SQL server databases from SQL server 2000 to SQL server 2005, and SQL server 2008.

Performed day to day Database administrative duties, such as monitoring the whole SQL Server environments.

Made sure DBA backup, optimizations jobs were running and working correctly. Governing the security of the SQL Server databases.

Pro-actively worked with the users on making sure availability, scalability and performance of the databases would be at the highest and most efficient level.

Worked on performance and tuning of the databases or developer's code to make sure the code is correctly optimized.

Confidential

MS SQL Server DBA

• Supported production and development environments of major online retail websites.
• Participated in implementation and provided support to the main POS, Data Warehouse, Accounting and Inventory system.
• Developed and implemented strategies for backup and recovery utilizing full, differential and transaction log backup methods.
• Created and implemented maintenance plans for each database to improve its performance and efficiency.
• Created and utilized the Transactional Synchronization of data between different servers using DTS packages and stored procedures.
• Implemented Migration process that involved conversion and manipulation of data between several systems.
• Successfully tuned database to better enhance performance. De-fragmented, rebuilt indexes. Recompiled and tuned store procedure to boost performance.
• Used profiler to monitor performance and detect performance issues.

• Maintained system security.

Confidential

Database Administrator/Senior System Programmer

• Worked on the development of a complete Financial Data Warehouse Reporting System. Data Warehouse System Cube structure contained financial data and allowed financial analysts to view this data in Excel Spreadsheets format. Provided performance evaluation, attributions and other services to clients.
• Responsible for the Oracle and MS SQL Server installation and upgrading.
• Implemented and maintained security system in test and production.
• Implemented the backup procedures for MS SQL server / Sybase databases
• Created and implemented system conversion from Oracle8i to Oracle9i . Successfully tuned database to better enhance performance. De-fragmented, rebuilt indexes. Recompiled and tuned store procedure to boost performance.
• Developed and implemented the Financial Data Warehouse Reporting programs. Used VB custom controls to graphically display data. Applications utilized ActiveX Controls in MS Visual Basic. The back-end was a Sybase database and Essbase database running on Sun Solaris OS. Applications interacted with the database using ActiveX Data Objects ADO and Essbase API functions to establish connection between Essbase and VB6. Created store procedures to transfer data from the Sybase data mart system to the Essbase Data Warehouse.