Summary

Interested in a position where my many talents and experiences can be harvested towards the fulfillment of strategic and operational business goals and practices.

RECENT EXPERIENCE

Confidential, (Sept 2006 - Present)
Roles: DBA & Developer (.NET, SQL, Java) - MS SQL Server [version 7, 2000, 2005, 2008], Oracle [version 11G, 10 G, 9i, 8i, 7.3]

Highlights & Tools

• 24 * 7 Support of Client\'s database systems
• Set up & maintained Database Clustering systems
• Configured Database Mirroring / Log Shipping / Replication
• Developed Microsoft Integration Services (SSIS) & DTS packages
• Developed Reports using SQL Server Reporting Services
• Installed new systems, upgraded & patched existing systems
• Performance Tuning
• Monitoring
• Multi-Instance systems setup & monitoring
• Data Exchange between MS SQL Server Systems and Heterogeneous data sources (Oracle, Sybase, MYSQL, MS Excel)
• Very Heavy usage of MS SQL Transact SQL (T-SQL)
• Very adept at understanding data flow requirements and developing Extract Transform Load (ETL) modules in SSIS/DTS/Transact SQL
• MS .NET Development work using C# and VB.Net (Also MS SQL Server CLR Development work)
• SOX Compliance – Data access & usage auditing
• System Hardening & Data security
• Networking (Firewall)
• Storage (SAN) - Connectivity, allocation & tuning
• Backup & Restore (Traditional database backup & restoration and 3rd Party – IBM Tivoli [TDP], Symantec [Backup Exec])
• Virtualization experience (VMWare, Microsoft Virtual Server – Hyper-V)
• Monitoring Tools (Microsoft MOM & Microsoft System Center)
• Setup database repository for numerous 3rd party products (Microsoft [SharePoint, MOM, SMS], Remedy, Research In Motion – RIM – BlackBerry, Citrix, Risk Master [Legal Software])
• Conversant with Microsoft front Office Technologies – MS Office (Word, Excel, Outlook). Very comfortable using them as an end-user and also programmatically (VBA, OLE Interop, 3rd party tools [Aspose])
• Very comfortable with MS Windows OS (Microsoft NT, 2000, 2003)
• Installation & Operation of MS Exchange (SMTP, MAPI, Anti-spamming configuration)
• Apache web server
• Oracle (some DBA & PL/SQL work, and also Transparent Gateway Configuration)
• Java\\JDBC\\Bea Web Logic development & database connectivity\\configuration work
• Some Linux
• Some MYSQL DBA work
• Some GIS Work

Confidential,(Dec. 2000 - Sept. 2006)
Roles: DBA, Data Architect, Data Modeler, Web Developer, Lead SQL Server DBA, Lead Developer
Work on all three major databases (Microsoft SQL Server, Oracle, and IBM UDB). Provide 24 by 7 coverage. Work on all application deployment tiers - Database Servers, App Servers [Bea Tuxedo], and Web Servers [Microsoft IIS, Apache].

Highlights & Tools

• Designed, configured, and maintained SQL Server Cluster
• Configured interoperability between MS SQL Server and Oracle & IBM DB/2 & UDB Servers
• Responsible for database daily maintenance, performance tuning, script coding, database backup & recovery, system connectivity, and security
• Participated in inter-department discussions and decisions on choice of hardware, storage, and network
• Databases located across the globe (Asia Pacific - Australia, Europe, Canada, and US)
• Work with management and end users to design new Applications - Study the business model and practices, designed application, ensure & build the infrastructure, deploy and manage
• Data modeling functions - Designed logical & physical data models for LOT and Decision support systems
• Very proficient with database modeling tools (Erwin, Embarcadero ER/Studio)
• In designing logical model, able to identify entities, determine relationship between entities, and define data integrity constraints
• In designing physical model, able to map logical model into a physical model that is suitable to the underlying characteristic of the database platform (whether MS SQL Server, Oracle, or IBM DB/2). Ensure that indexes, views, stored procedures, triggers, and constraints are used effectively
• Reversed Engineered existing databases into logical model - In doing so able to educate and share existing data repository with others and prepare system for maintenance, upgrade, or retirement
• Able to predict and determine data hotspots and spread data entities (actual data, log, and indexes) across unique physical drives
• Proficient at optimizing database queries (using re-written queries, indexes, partitions, archiving, and materialized views)
• Well verse experience with MS SQL Transact SQL (T-SQL)
• Rich set of expertise in understanding data flow requirements and developing Extract Transform Load (ETL) modules in SSIS/DTS/Transact SQL
• Proficient with XML, XSLT
• Comfortable with Web Services and Soap
• Adept at using reporting tools (MS Reporting Services [SSRS], Crystal Reports, COGNOS)
• Used Microsoft SQL Server DTS packages extensively
• Configured Replication between MS SQL Server Instances
• Web Development work - Microsoft - ASP.NET, C#, VB.NET
• Web Development work - Java - JSP, Servlet
• Very comfortable with MS Windows OS (Microsoft NT, 2000, 2003)
• IBM Notes (Programming)
• Apache web server
• Oracle (some DBA & PL/SQL development work)

Confidential, (May. 1999 - Dec. 2000)
Roles: DBA, Data Architect, Data Modeler, Web Developer, Lead Developer, Systems Engineer
Managed multiple Microsoft SQL Server databases. Supported Web Community system. End users were allowed to register, subscribe to newsletters, and participate in virtual communities.
Co-designed & developed Java based Email Newsletter distribution system.

Highlights & Tools

• Installed and configured LDAP Directories (MS Active Directory & MS Site Server)
• Wrote applications using Microsoft ASP, ADSI (Active Directory Service Interface), VBScript, Jscript, and Visual Basic
• Microsoft IIS
• Borland\'s Delphi
• Microsoft\'s SQL Server
• Microsoft\'s Transact SQL
• Microsoft Visual C++
• Erwin
• Embarcadero ER/Studio
• Designed logical & physical data models - Able to study business, design, socialize, & tune data models

Confidential, (April 1997 - May 1999)
Roles: DBA, Data Architect, Data Modeler, Web Developer, Lead Developer, Systems Engineer
Developed and maintained numerous systems that helped customer service track customers investments.
Highlights & Tools

• Microsoft Visual Basic
• Microsoft IIS
• Microsoft\'s SQL Server
• Microsoft\'s Transact SQL
• Visual Cafe Java
• Microsoft MTS (Messaging)
• Database modeling tools (Erwin)

Confidential,(Dec. 1997 - May 1999)
Roles: DBA, Data Architect, Data Modeler, Web Developer, Lead Developer, Systems Engineer, Sustaining Engineer
Responsible for streamlining distributed architecture for a system that supports global web hosting infrastructure. Completely rewrote sales, customer support, and Inventory management system.
Highlights & Tools

• Microsoft SQL Server
• Borland Delphi
• Microsoft IIS
• Crystal Reports

Confidential,(May 1997 - Dec 1997)
Roles: Web Developer, DBA
Responsible for designing and implementing Internet Commerce Site.
Highlights & Tools

• Microsoft Internet Information Server (IIS)
• Microsoft Active Server Pages (ASP)
• Microsoft Transact SQL
• HTML & JavaScript

Siemens Communication (Dec. 1996 - May 1997)
Roles: DBA, Developer
Managed SQL Server databases. Responsible for converting legacy applications to Java. Developed a gateway application written in Java. The application receives requests from the PC and services those requests on a DB/2 database system residing on MVS. The communication module consists of JDBC, JDBC-ODBC bridge, ODBC, and SNA.
Highlights & Tools

• Microsoft SQL Server
• Microsoft Internet Information Server (IIS)
• Microsoft Active Server Pages (ASP)
• Microsoft Transact SQL
• Java & JDBC
• HTML & JavaScript

Confidential, (May 1996 - Dec 1996)
Roles: Architect, Lead Technical Developer
Lead programmer on a project that tracks home mortgages. The GUI was written in Delphi; and the backend was an Informix database.
Utilized object oriented techniques to build components. Tuned database to optimize performance.

Highlights & Tools

• Borland Delphi
• Informix Database
• Microsoft Visual Basic
• SQL

Confidential, (August 1993 - May 1996)
Roles: Architect, Project Lead, Lead Technical Developer
Developed Human Resources application. Application allowed company to track employee\'s information. Information tracked included organization\'s flow-chart, security and access data, and employee\'s personal data.
Gained tremendous hands on experience managing Microsoft SQL Server databases. Databases were installed and utilized nation wide. Responsible for all remote SQL Servers. Provided database training to programmers and end-users. Offered solutions to end-user questions regarding database maintenance, optimization, networking, and programming.

• Microsoft Visual Basic
• Microsoft SQL Server
• Microsoft C++ (Foundation Classes)
• Borland Delphi
• Informix Database
• Microsoft Visual Basic
• Power Builder
• SQL (Sybase, SQL Server, DB/2)

In the past worked for the following companies:

• Broadway & Seymour, Columbia, SC. August 1992 - August 1993. Software Developer. Developed applications using C, C++, Presentation Manager (PM), SQL, and IBM DB/2 and IBM Communication Manager.
• American Express Health Systems Group, Charlotte, NC. Sept. 1990 - August 1992. Network Specialist. Assisted in managing a Novell Network with thousands of hosts. Hosts included PCs, Mackintosh, IBM and DEC terminals. Configured file servers, gateways, bridges, hubs, and modems.
• Sunbelt Computer Systems, Charlotte, NC. May 1990 - Dec. 1990. Designed financial database applications for sale to credit unions. Programmed in Visual Basic.
• Project Ready, Charlotte, NC. August 1988 - September 1999. Designed touch-screen based tutorial applications. Tutorials were for students in state funded post-secondary institutions and adult education.
• IBM, Charlotte, NC. Jan. 1988 - Aug. 1988. Assembler. Assembled copiers and printers.
• Carolina Medical Center, Charlotte, NC. Jan. 1986 - Mar. 1987. Designed Analysis applications that helps track participants health habits. Applications were written in Basic, Pascal, and SPSS.

Education

Bachelor of Science. Electrical Engineering Technology

Skill Sets

Years

DBASE/Paradox/Clipper

6 years

Delphi

6 years