SUMMARY:

• Various project management and team leader roles
• Program Manager to a team of marketers, programmers, and store men
• Branch Manager for a computer distribution company
• More than 15 years in SQL Database server admin., Web server admin., Window Network admin., Software Design and Development (from initial conceptualization through to completion) with more than seven years in the management/team lead role. Independent with good interpersonal and organizational skills.
• To seek a challenging position in an environment that allows me to utilize and enhance my knowledge and skills. Ultimately, to be a successful and admirable IT professional who can contribute to the profitability of your company and the well - being of our society

TECHNICAL SKILLS:

Databases: MS SQL2012 (SQL Mgt. Studio, DTS/SSIS, SQL Analysis/ Reporting Services), Tableau, Oracle (SQL*Plus, Toad, SQL Navigator), Sybase (Sybase Central, Sybase Advantage), DB2 (PCOM, IBM Application Development Client), MS Access. Experience in database migration, ETL, analysis/data-mining, optimization/tuning, query execution plan/index analysis, replication, geo log shipping, clustering, mirroring, full-text search, backup/restore operations

Major Languages/Interfaces: Visual Studio .Net 2008 (ASP.Net, ADO.Net, VB.Net), Visual Basic 6.0 (ADO,COM,DCOM), Visual FoxPro 6.0, SQL Windows, OLEDB, ODBC, MAPI, WIN32 API/Programming

Administration: Window 2012/2008/2003/2000/ NT Network, IIS Web Server & OLTP/OLAP SQL Server 2012/2008/2005 administration

Operating Systems: Window 2012/2008/2003/2000 server, Window 7/Vista/XP, NT4 Server, MS DOS, Music, Unix

Application Tools: BMC Patrol, Quest Diagnostic Suite, Idera, Litespeed, Sql Backtrack, Symantec Backup Exec, Tivoli Tape Backup, EMC Navisphere/SAN, VPN, Windows Remote Desktop Administration, VNC, PC Anywhere, Crystal Report, MFS/MS SourceSafe, MS Projects, MS Visio, MS Office, ArcView, Lotus Smartsuite, SAS, POP3 mail, Lotus CC mail

Web: ASP.Net, ADO.Net, XML, IIS, ColdFusion, VB Script, ActiveX, Java, Java Script, HTML, DHTML, Remote Scripting, Encryption (Asym & Sym, RSA, Rijndael, TripleDES)

Multimedia: Photoshop, Premiere, Authorware, Director, Sound Forge

Networking Devices: Connectivity and programming skills in Cisco routers, switches, hubs

Protocols: TCP/IP, SMTP, RIP, IGRP, OSPF, EIGRP

PROFESSIONAL EXPERIENCE:

Senior Consultant/Database Administrator

Confidential

Responsibilities:

• Lead DBA for ~100 Sql2012/2008 database servers with databases up to several terabytes in size
• Spearheaded (served as Project Manager) the upgrade/migration of many Sql clusters/servers from Sql 2005, Sql 2008 to Sql 2012 Edition
• Recommended and implemented various topologies for multi-location HA/data redundancy including clustering, mirroring, log-shipping and replication
• Performed extensive troubleshooting from analysis to fault isolation to resolution
• Assessed and implemented standard best practices for optimal database management
• Built consensus on SQL upgrade/patching methods and timelines with various directors/managers
• Conducted regular monitoring (Quest Spotlight), performance tuning and optimization
• Rewrote scripts for developers to alleviate blocking and deadlocking issues thereby cutting down executing time up to 5 times
• Relocated database files to take advantage of IO parallelism
• Optimized tempdb for better performance
• Provided mentoring and guidance to several intermediate level DBAs
• Participated and presented in regular Change Control meetings
• Worked with a DBA team to provide 24/7 administrative supports

Senior Technical Analyst/DBA, AVP

Confidential

Responsibilities:

• Worked with a global team to provide 24/7 administrative supports for
• Multi mission-critical high volume Global Market Trading systems
• 350 Sql 2008/2005/2000 OLTP and OLAP servers with thousands of databases
• Backup/recovery and COB via clustering/geo-log-shipping/mirroring/replication
• Resolved issues related to locking, statistics, query plan, corrupted/suspended dbs, disk space and resource-pressures from i/o, memory and cpu contention
• Provided supports and recommendations for better performance to various software developers
• Implemented user access controls and security policies for all Sql servers
• Upgraded/Migrated multiple Sql clusters/servers from Sql 2005 to Sql 2008/R2
• Implemented various operational database maintenance automation using scripts
• Built Consensus on SQL upgrade/patching methods and timelines with various project managers
• Provided mentoring and guidance to several junior and intermediate level DBAs
• Facilitated in the hiring/interviewing process for 2 Senior and 1 Intermediate level DBAs
• Received the Recognition s for Valued Employees (R.A.V.E.) 3 times in 3 years of services

Database Analyst III

Confidential

Responsibilities:

• Led the management of clustered Sql servers providing support to mission-critical Catalog/Retail sales systems
• Database system: evaluated and designed enhancements to improve overall performance
• Application system: recommended changes to vendors highlighting areas that need improvements
• OLAP database mining: used Sql and Excel to extract and analyze sales data
• Facilitated in the annual key rotation of encrypted Sql databases for PCI Compliance purposes
• Setup and maintained several multi-node (up to 8 nodes) clustered Sql 2008 OLTP production environment
• Doubled up as a MicroStrategy DBA providing administrative support for several BI systems
• Designed RDBMS including conceptual ERD, logical, physical modeling
• Provided administrative support for SSAS, SSIS, SSRS OLAP servers
• Resolved various performance problems:
• Indexes issues
• Corrupted tables and meta-data
• Table purging and partitioning

Senior DBA

Confidential

Responsibilities:

• Designed and developed dynamic SSIS packages for the transfer of audit data between servers for archiving purposes
• Led the comparisons of performance between SQL 2000 and SQL 2008 using SQL profilers
• Evaluated various strategies using mirroring and replication for implementing multi-location data redundancy

Senior DBA

Confidential

Responsibilities:

• Managed and supported more than 100 clustered SQL 2005 instances including some OLTP instances with 100 transactions/sec
• Monitored databases usages and provided solutions to various database login, locking, backup/ restore and disk space problems
• Created SQL maintenance jobs to run on the Control-M batch scheduling application
• Facilitated code releases through the Change Management Control processes

Senior DBA/Consultant

Confidential

Responsibilities:

• Managed reporting services, integration services and analysis services on a 3.5 TB OLAP datawarehouse hosted on SQL2005 database servers
• Built SSAS cubes and performed data mining on sales data using SQL and MS Excel pivot tables
• Conducted performance tuning and optimization using Query Analyzer, Index Tuning Wizard, SQL Profiler and System Monitor
• Rewrote scripts for developers cutting down executing time up to 8 times
• Reorganized data files to improve overall performance by reducing i/o and paging
• Fine tuned memory usages and settings (/3GB, PAE,AWE) on servers to significantly speed up response time
• Facilitated actively in Change Management Control and Sarbanes-Oxley Compliance efforts
• Managed changes using Samantha's change management software
• Generated various audit reports for SOX auditing purposes
• Designed and managed tight security for access to all production SQL servers
• Created SQL job status and backup reports using SQL reporting services (SSRS)
• Created various highly complex Stored Procedures, ETL packages for daily load of datawarehouse using SQL DTS/SSIS and DM Express
• Converted various ETL DTS packages to SSIS packages and resolved various upgrade issues from SQL2000 to SQL2005
• Implemented SQL backup/restore using Idera and Litespeed backup software
• Implemented snapshot and transactional replications for disaster recovery (DR) purposes
• Designed and managed the layouts of database files on three EMC SANS storages for use by various SQL 2000 and SQL 2005 database servers
• Spearheaded the installation and configuration of Quest Diagnostic tools including Quest Spotlight, Capacity Monitor and SQL Watch
• Served as a lead DBA on an infrastructure support team for a nationwide project using MS SQL as the backend OLTP database server
• Spearheaded the design and development of complex SQL queries for the extraction of hierarchical information; Created DTS packages for the extraction of millions of rows of records
• Monitored databases usages and provided solutions to various database login, locking, log shipping, backup/restore and disk space problems
• Analyzed and developed complex SQL queries for Management Reporting purposes
• Setup Microsoft ‘Failover Clustering’ for SQL 2000 database servers using Windows 2003 servers
• Designed and created DB2 SQL queries using the PCOM and IBM Application Development Client as part of a data migration project
• Setup Microsoft Virtual server 2005 for testing and purposes

Database Administrator/Systems Analyst

Confidential

Responsibilities:

• Led the management of multiple mission-critical SQL2000 database servers. Tasks include server upgrades, data migrations, data transformations, database queries/reports, database design, tables/stored procedures/views/triggers creation, tuning, replication, log shipping, clustering, full-text search, backup/restore operations
• Led in the management of the -Winning city web site and city web servers. Managed user rights, security updates, web pages creation and updates
• Setup and managed ‘Failover Clustering’ on mission critical application/database servers and the city web servers
• Spearheaded (served as Project Manager) the design and development of the -Winning Agenda Record Management System used throughout the city. This system was integrated with the Exchange/Groupwise mail, Microsoft Word and the SQL2000 database
• Led in the implementation of the Agenda Record Management System at several client cities
• Led in the conversion of the Agenda Record Management System into an Asp.Net web application
• Setup and managed snapshot/transactional replications for data redundancy
• Led in the upgrade/migration of various highly complex servers with minimal vendor support saving thousands of dollars for the city
• Participated in managing a large multi-segments/locations Win2003/Novell networks with about 500 workstations and hundreds of printers
• Setup Window2003 Enterprise server, Window2000 Advanced server with Active Directory and Exchange2000 server in the test environment
• Led the evaluation and testing of various Web Content Management software including the Microsoft Web Content Management, Microsoft Portal Server, Plumtree Portal, and similar products by Rhythmyx, Fatwire, RedDot, Openshare, Cyberteams
• Led in the evaluation of software and hardware requirements for major servers replacements
• Influenced and guided various vendors on multiple update/upgrade/migration projects

Programmer Analyst

Confidential

Responsibilities:

• Designed and developed an application using Visual Basic (ADO,COM,OLEDB,ODBC)/SQL database to help measure the success of a marketing campaign
• Designed and developed an application using Visual FoxPro/SQL database that enabled the billing department to recoup several hundred thousand dollars quarterly
• Developed COM objects to facilitate the migration of a billing system from SQL server to Sybase server
• Facilitated in a massive SQL database cleanup project that involved millions of records
• Implemented enhancements to a Trouble Tickets System used by hundreds of users