SUMMARY:

• More than 12 years of experience in various databases - MS SQL Server, Oracle, Teradata and Sybase as Sr. Developer, DBA and Data Architect.
• Experience with Cloud computing using AWS(Amazon web services) and Microsoft Azure.
• Expert level skills in Business Intelligence(SSAS), T-SQL, Performance Tuning, Server Administration, Data Architecture, Data Design.
• Extensive Data Integration, Migration, Master Data Management, Validation and processing experience.

TECHNICAL SKILLS:

RDBMSs: MS SQL SERVER 2014/2012/2008/2005/2000, Oracle 11g/9i/8, Teradata 14.x, Sybase12.5/11.x

Operating Systems: WINDOWS 2008/2005/xp, WINDOWS-NT, Novell NetWare, Linux, SOLARIS, UNIX, SUN-OS, HP-UX.

BI Tools: SSAS, Tableau and SSIS

DB Tools: T-SQL, Teradata SQL Assist, PL/SQL, SQL Plus, CYRANO Workbench V3.1.3, SQL MONITOR, ECOPMON, Data pump, ASM

OLE DB Sources: LINKED SERVERS, DISTRIBUTED Queries, OPEN Queries, ODBC Sources, DESKTOP DBA V4.1, Embarcadero ERStudio Data Architect 8.5, Embarcardero DBArtisan 5.1, SQL Backtrack V4.0.0, Sybase SQR, Sybase DB-Library.

Other Tools/Tech: SSRS, Informatica 8.x/9.x, MS SQL Server Management Studio 9.0, MS SQL Server Profiler 9.0, MS Performance Monitor, ERWIN r 4.1/7.1.3/9.2, PowerDesigner, Visual Source Safe, PVCS Dimensions V5.0 SP2, DTS Packages, MS EXCEL, ER/Studio 7.5,Veritas, TCP/IP layers, Active Directories etc, Teradata OLELOAD, PowerShell.

PROFESSIONAL EXPERIENCE:

Confidential, Providence, Orange

Sr. Database Administrator

Responsibilities:

• Typical service tickets included deadlock transaction resolution, disk space management, performance tuning on legacy and non-legacy reports.
• Also part of migrating SSIS to Informatica project on Admin side. Tasks include deployment of new code to various environments.
• Performance tuning and troubleshooting migrated code - including re-designing stored procedures working with developers to test joins, breaking up queries, replacing cursors with smarter code, showplan analysis, index evaluation, index management and development etc.
• Troubleshooting and fixing stored procedures using XML as input parameters.
• Also designed and implemented dynamic purge process of history and error tables thus resulting in additional free disk space.
• Also used Informatica PowerCenter client tools like Repository Manager and Workflow Manager to deploy/migrate workflows to/from various environments.
• Also evaluated various data migration tools and trends to and from AWS Cloud platform. After completing evaluation I implemented Direct Connect to AWS Cloud and successfully implemented the migration.

Environment: Microsoft SQL Server 2012(SP1) x64/2008 (R2), Informatica V10.1.1, Informatica Client Tools, SSIS, AWS Cloud, SSMS, Quickbase, Tableau 10.1.3, Redgate

Confidential, Rancho Mirage

Sr. Database Administrator

Responsibilities:

• Typical service tickets included deadlock transaction resolution, server tuning, SQL Server installation and configuration, SQL upgrade, Security setup, data security policy implementation, Linked Servers setup, Kerberos authentication, SQL Services security, SQL Agent jobs setup, Capacity planning, backup planning and setup, Cluster setup and configuration.
• Oracle server support included disk management(ASM), drive extension, RMAN backup setup, Cold backup, User account setup and permissions management.
• Development tasks included data script implementation and execution, ETL projects using SSIS and Jitterbit as data extraction and migration tools. Troubleshooting and fixing SSAS code to resolve month-end report errors.
• Writing and implementing customized script to identify and flag SQL 2005 servers for upgrade.
• Project Management - Meeting and communication with analysts and user groups to discuss and implement their projects.

Environment: Microsoft SQL Server 2014/2012(SP1) x64/2008 (R2)/2005, Oracle 11g, 9i, Linux, Grid Control, Aquadata, Oracle Enterprise Manager(OEM), SQL Management Studio, SSAS, SSIS, Jitterbit, SDE

Confidential, Irvine

Sr. Data Architect/Analyst

Responsibilities:

• Thus I started with designing a Data Warehouse which would store accumulated Sales/Revenue Data across Territory/Region, Product, Customer and Date Hierarchies using SQL Server Analysis Services.
• Attended Tableau Developer and Server to fully integrate Tableau 9.0 as a presentation tool exposing Cube data processed nightly.
• Installed and configured Tableau Server and created several Tableau Dashboards for the Sales Team and designed and managed workbook sharing across Sales and Executive team.
• Also designed and developed Inventory Availability and Management reporting tool using T-SQL stored procedures. This report uses dynamic SQL to create/extend column headers based on the Date Range entered by the user. Also keeps track of row level and column level totals and calculations which are performed and processed after each product item listing.

Environment: Microsoft SQL Server 2012(SP1) x64/2008 (R2), MS Visual Studio Premium 2012 Ver 11.0, MS Visual Studio 2008, Tableau Ver 9.0, SSAS, SSIS, IQMS Oracle 11g

Confidential, Rancho Santa Margarita

Sr. DBA/Data Architect

Responsibilities:

• As a Data Architect designed and developed Data Warehouse environment with several cubes processing daily with Excel 2013 as the presentation layer.
• Also managed and developed several modules to interface with IBM Silverpop by scripting in PowerShell.
• Developed a prototype presentation layer using Tableau 8.2
• Setup and maintenance of Transactional Replication to supply production data to 2 distinct SQL Servers - Reporting Server and Data warehouse SQL server.
• Reporting server feeding data to Crystal and SSRS reports whereas Data warehouse SQL server acting as a relational schema for SSAS.
• Other day-to-day tasks are bug fixes on SQL side and designing and developing custom reports for Silverpop and other application, writing scripts to monitor services and disks 24/7.

Environment: Microsoft SQL Server 2012(SP1) x64/2008 (R2), MS SQL Server Replication, MS Visual Studio Premium 2012 Ver 11.0, MS Visual Studio 2008, MS Office 2013, Tableau Ver 8.2TFS Foundation Server, IBM Silverpop Engage, PowerShell, C#

Confidential, Irvine

Sr. DBA

Responsibilities:

• Performing performance tuning on all servers, including OLTP and DW databases using SQL Profiler, Showplan, Spotlight, Index Optimizer.
• Also put in place server/data security policies, capacity planning, disaster recovery/backup policies, Maintenance Plan design and customization, disk management.
• Design and development of new database modules to be lined to the website as new features.
• Developed stored procedures using XML features to process telecom files.
• Design and development of ETL modules loading/processing of continuous telecom feeds from various vendors, partners using SSIS.
• Being responsible for all Servers/Database I also provided 24/7 support.
• Day-to-day administration alerts and subsequent fixed included:
• Transactional Replication broken/out-of-sync
• Transaction Log growing too big
• Transaction Log not getting truncated
• Replication not releasing log.

Environment: Microsoft SQL Server 2008 (R2)/2005,Microsoft SQL Server Integration Services, Microsoft SQL Server Replication, BIDS, Spotlight, Quest SQL Optimizer for SQL Server.

Confidential, Phoenix/Lake Forest

Lead Developer/DBA

Responsibilities:

• Started with data gathering requirements and data process flow roadmap, following it with data Analysis, Logical/Physical design, Data Flow Diagram(DFD) in VISIO, database creation and data migration.
• SAP/Sybase Powerdesigner was used to reverse engg Teradata database to produce final model.
• Supported Microstrategy developers by developing Macros, views and stored procedures.

Environment: Teradata 13.x/14.x, Microsoft SQL Server 2008 (R2), Microstrategy, Informatica PowerCenter 9.x, Teradata SQL Assist, Teradata OLELOAD, ERWIN r9.2, Unix SUNOS.

Confidential, Irvine

Lead Developer/DBA

Responsibilities:

• Compared AWS /Azure for cloud computing platforms.
• Also designed and developed SSAS cubes for MIS reporting purposes.
• Also evaluated Golden Gate and SQL Replication as the preferred tool to be chosen for 2 way data replication across geographical sites.

Environment: Microsoft SQL Server 2008 (R2), Microsoft Integration Services Server 10.0.1600, SSAS, Microsoft Reporting Services Server, Microsoft Integration Services Server(SSIS), Spotlight, Solarwinds, Splunk, SAS, AWS, Azure, Golden Gate

Confidential, Burbank

Lead Developer/DBA

Responsibilities:

• As the Database Lead my primary responsibility is Sybase 12.5 and Oracle 11g migration into
• SQL Server 2008 for selected relational databases, accompanying database code, scripts and users.
• Microsoft’s SSIS and BCP was used to migrate Sybase data into SQL Server 2008.
• All CRON scripts were converted to SQL Server’s Agent jobs.
• Stored procedure coding and bug-fixing migration problems.
• DOS scripting to accomplish nightly processing of bulk-data.
• Shell script (csh) conversion/migration to SSIS packages and DOS scripts.

Environment: Sybase 12.5, Oracle 11g, Microsoft SQL Server 2008 (SP 1) - 10.0.2531.0 (X64), Windows NT 5.2 (X64) Microsoft Analysis Server 10.0.2531, Microsoft Integration Services Server 10.0.1600, UNIX-SunOS, Linux, Microsoft Reporting Services Server, Informatica PowerCenter 8.x, ERWIN r7.3.12.

Confidential, El Segundo

Lead Developer/DBA

Responsibilities:

• ETL design and development - Oracle to SQL data flow using SSIS and eventually Informatica.Staging server design and development
• Target server design and development
• Requirements document design and creation
• Architecture document design and creation
• Business process translation and conversion

Environment: Microsoft SQL Server 2008 (SP 1) - 10.0.2531.0 (X64), Windows NT 5.2 (X64), Oracle 9i, Microsoft Analysis Server 10.0.2531, Microsoft Integration Services Server 10.0.1600, Microsoft Reporting Services Server, Microsoft Integration Services server(SSIS), Informatica, Oracle 9i, Embarcadero ERStudio Data Architect 8.5, Microsoft Excel 2007, Microsoft Visio 2007, Microsoft PowerPoint 2007.

Confidential

Technical Lead

Responsibilities:

• >Vendor Status meetings - Bug-fix management on Sharepoint. >Vendor Patch installation >Vendor S/W Release management
• Real time monitoring of Usage Statistics/Cache statistics/CPU functions, migration of Oracle databases to QA/DEV/SANDBOX environments.
• Also setup and monitoring of complicated Oracle RMAN processes to DR environment on VLDB with source server on one end of the country and target server on the other.
• Failover processes were also setup on the DR server.
• Performance tuning on VLDB database using Idera application to monitor memory/cpu/disks usage and also tuning database code. Also leading the vendor application bug-fix patch implementation process - testing - DEV/QA test procedures setup for each patch version - verification of test scripts and results and also implement config file changes across servers keeping in sync with different database names in each environment. Setup and testing of clustering on QA servers.

Environment: Oracle 10g on SunOS, Informatica, BCP, Microsoft Integration Services server(SSIS), IDERA Database Solutions, Visual Studio, ASP .NET, Powerpoint, Sharepoint

Confidential

Responsibilities:

• >Vendor Status meetings - Project scheduled task completion status. >Schedule and plan QA/PROD environments releases >Powerpoint presentations to the Management
• Converted over 25 CRON scripts over to Oracle environment to maintain data transfer to and from various systems enterprise wide .
• Documented all migrated databases using ERWIN 7.3 Logical and Physical data models and Process Flow diagrams depicting all ETL interfaces.

Environment: Oracle 10g, Sybase 11.9.2, MS-SQL Server .760, DB2/AIX, WINDOWS XP Professional, Microsoft Management Console 3.0, MS SQL Server Management Studio 8.0, MS SQL Server Profiler 8.0, MS SQL Server Performance Monitor, Enterprise Manager V8.0, Query Analyzer V8.0 0, ERWIN 7.3, Microsoft Reporting Services server(SSRS), Informatica, BCP

Confidential

Responsibilities:

• Responsibilities included design, development and testing of Data Warehouse ETL packages to various outside vendors using DTS packages, Stored Procedures and scripts - Selecting, Filtering and Exporting terabytes of data and also modification of web-pages in VB .NET and JAVA.
• Performed major performance tuning on the site using SQL Profiler Traces in conjunction with analysis of Performance Monitor data and identification and enhancement of several stored procedures using inner/outer and cross-server joins.
• Also performance tuned various SSRS reports selecting huge data sets across partitions using SQL Performance Monitor, configuring new Counters to measure performance and also tuning Stored procedures for optimum performance.

Environment: MS-SQL Server 20 .760, Sybase 12.5, WINDOWS XP Professional, Microsoft Management Console 3.0, MS SQL Server Management Studio 8.0, MS SQL Server Profiler 8.0, MS SQL Server Performance Monitor, Enterprise Manager V8.0, Query Analyzer V8.0 0, Microsoft Reporting Services server(SSRS), Microsoft Integration Services server(SSIS), VB .NET

Confidential, Burbank

Responsibilities:

• As the project lead my responsibilities included 24/7 support of all studio IT databases. Currently supporting 10 databases, responsibilities include all change/enhancement requests from Web/Powerbuilder developers and also making sure 24/7 database availability.
• Also setup and monitored RMAN backup/restore processes to DR environment on VLDB.
• Also defined Performance Tuning strategy executed by setting up PerfMon counters and developing script to interpret PerfMon outputs into user-friendly reports and also setting and scheduling Backup jobs.
• Set-up and testing of complete clustering solution on production servers.

Environment: Oracle 9i, UNIX SunOs V5.6 & V5.8.

Confidential, Los Angeles

Responsibilities:

• Development team build-up - interviews/selection >Development teams hours management >Technical mentorship >Vendor meetings to request and procure system documentation >Vendor S/W Release management
• Also developed validation coding structure using T-SQL code in stored procedure/triggers and extensively using permanent and temporary tables. As this required complex business logic checking a lot of analysis was required prior to actual coding.

Environment: MS-SQL Server, WINDOWS 2000 (Pro), Enterprise Manager V8.0, Query Analyzer V8.00, SQL Profiler V8.00, Visual SourceSafe V6.0c, Mercury TestDirector V8.0, MS EXCEL.