Resume

Objective:

SQL Server DBA with over * years IT experience, including more than 5 years as a developer in technical industry. Proficient in SQL Server 2000,2005, and 2008, Oracle 8i, 9i, and 10g, PL/SQL, ASP, .Net, C# and Visual Basic; possess strong communication and problem solving skills developed through a variety of projects. Offer proven ability in team leadership and proactive systems support. I received B.S. degree in Computer Science from University of Houston, TX.

Technical Skills:

Programming Languages: Visual Basic 6.0 , C, C++, Java, C#, ASP, ASP.Net

Web Technologies/Systems: HTML, ASP, VBScript, Microsoft Front Page 2000, Macromedia Flash 5.0

Database Technologies / Systems: ODBC, Oracle 8i, 9i, & 10g, Access 2000, Microsoft SQL Server 2000, 2005 and 2008, PL-SQL, SSRS, SSAS, SSIS, Data Warehousing, Data Mart

Operating Systems: Windows 9x/NT/2000, UNIX

Other: Visual Fox- Pro, UML, OOP, OpenGL, Prolog, LISP, XML, COM, Dreamweaver, TCP/IP, MS Visio, ADO, Visual Interdev, Crystal Report (8.5 & 10), Visual Age,.Net, VB.Net, PHP, , T-SQL

Certification Oracle (9i) DBA , MCITP(SQL Server 2000 & 2005 DBA and Developer) , PeopleSoft(In Progress)

Experiences:

• ENI Petroleum (August 2008 to Present)

DBA Manager

Lead the team of DBAs to provide support to various database system including SQL 2005 and Oracle 8i to 11g. Provide support to security and disaster recovery process for organization. Create project plan and implementation process from development to production with the plan and documentations. Implement the best practice of user access and support for the database system. Provide support to create data warehouse system for data storage as well as SQL Business intelligence for reporting and ETL processes.

• Create Database security process for the organization.

• Provide support and decision making process for the new system design and planning.

• Manage team of DBAs for symbolization of duties

• Support SQL system and enhance the performance.

• Provide support with optimization and Tuning of SQL and Oracle Database System

• Provide support for Disaster recovery process and design.

• Design business intelligence system for company wide reporting and data warehouse system.

• Support ETL support for data transfer process between various sources.

• Spectra Energy (April 2007 to August, 2008)

Business Intelligence Administrator / Sr. Database Administrator

Lead the Data team through requirements, design and development for a complete overhaul of the Business Intelligence system at an Oil and gas company. Responsibilities throughout the full life cycle included data architecture design, logical and physical data model creation, requirements gathering and analysis for reporting and operational capabilities. Provided support to implementing Data Warehouse / Business Intelligence solutions and utilizing an extensive portfolio of experience and best practices. Responsibilities included conducting technical needs of reporting architecture, data warehousing, Data transfer, and serving as a subject matter expert in business intelligence concepts. Created and maintained company wide Business intelligence environment including SSIS, SSAS, SSRS, and SQL server 2005.

• Helped convert Business Object report to SSRS tool of SQL server 2005.

• Worked extensively with the other departments for their needs of reports, SSIS, SSAS, SSRS and data warehousing.

• Create and maintain BI environment for groups and departments in company.

• Configure Replication, Log Shipping, and Failover clustering to meet customer needs for

Production environment to development environment.

• Provided support for Reporting services such as Analysis Cube Processing, Reporting services Pro-Clarity.

• Supported ETL process of the company to provide better business model and structure of database system.

• Supported team with expert needs of creating and maintained company wide reporting structure in SSRS.

• Implemented system where internal and external users can access reports from SSRS environment.

• Applied security for users to access Dashboard and reports.

Environment Used: SQL Server 2000,2005 and 2008, SSIS, SSAS, SSRS, Data warehousing, Data Modeling.

• The Planet (May 2006 to Jan 2009)

Sr. Database Administrator / BI Administrator / Developer

Lead the Data team through requirements, design and development for a complete overhaul of the Business Intelligence system at company. Lead the team of DBA and Developer to provide maintenance support and installed more than 20 instances SQL servers. Supported migration from 2000 to 2005 SQL server environments. Performed all aspects of database administrator, Database Mirroring, including data modeling, backup, recovery, Disaster Recovery, OLAP processing for Analysis services, and replication. Also provided support to design and implementations of company wide disaster system for database system, which includes Replication, Database mirroring, Log shipping and Cluster environment. Provided support on CRM system for implementation and maintenance. Create BI environment and provide support to developers and users requirements. Help testing SQL server 2008 for future migration process and define process and document for reference during transformation from 2005 to 2008.

• Work closely with application developers and business users to design databases

• Create and maintain BI environment for groups and departments in company.

• Configure Replication, Log Shipping, and Failover clustering to meet customer needs for

Production environment to development environment.

• Provided support for Reporting services such as Analysis Cube Processing, Reporting services Pro-Clarity.

• Supported ETL process of the company to provide better business model and structure of database system.

• Supported multi dimensional data modeling for data warehouse system.

• Provided support to create better database architecture to support business intelligence.

• Provide support to developers/testers to resolve technical problems with data and/or databases.

• Schedule and Deploy schema changes, data conversion, data fixes and packages throughout many different environments including Development, System Test, UAT, Production, Training and several others

• Identify the processes and data repositories throughout the organization, which capture information about IT assets and understand how they effect, and where they fit, into the Life Record phases of an IT asset. Created a database of consolidated IT asset information accessible for query and report via a web browser.

• Lead a team of database developers in the extraction, transformation, and load process from of a different file base system to SQL base such as Access, Oracle, Excel, and flat files.

• Convert customer requirements into logical and physical database designs and models.

• Help testing new SQL 2008 CTP for future migration from SQL 2005.

• Create, modify, and maintain written documentation and modify existing stored procedures, triggers, and views.

Environment: SQL Server 2000,2005 and 2008, Oracle 8i, 9i, & 10g, SSRS,SSIS,SSAS.

• Home123(New Century Financial Corp) (September 2005 to May 2006)

Database Administrator / Developer

Database Administration experience as a Production and Development DBA. Data Analysis: Architecting corporate data migrating through transaction systems, OLTP and OLAP systems, Data Warehouse systems into archival systems. Database Design: Data Modeling and design. Database Design for referential integrity and performance. Development of Business rules implemented as Constraints, Triggers and or Stored Procedures. Experienced with EDI and markup languages. Routine DBA activities: Backup and Data recovery, Data security, Data Migration, Performance Tuning, Capacity Planning, DBMS monitoring, Data Integrity analysis, User Management, and Log Analysis.

• Work closely with application developers and business users to design databases

• Design databases using Visio and Erwin at the ORM, logical and physical level.

• Implementation Batch processing Performance monitoring and tuning SQL Trace / SQL Tuning Oracle Logminer Process automation.

• Oracle Fail Safe (High Availability) implementation and support Database replication Data cleansing, extraction and monitoring SQL Programming PL/SQL Programming Backup plans.

• Supporting Oracle 9i database system and optimizing the requirement of the system.

• Storage re-arrangement and savings Oracle database security and patching Oracle database capacity analysis and planning Archived records Oracle database (data warehouse) implementation.

• Participate in the definition, documentation and application of our Coding and Naming Standards.

• Provide support to developers/testers to resolve technical problems with data and/or databases.

• Lead a team of database developers in the extraction, transformation, and load process from of a different file base system to SQL base such as Access, Oracle, Excel, and flat files.

• Convert customer requirements into logical and physical database designs and models.

• Perform database maintenance and modifications to ensure databases are operational, as well as diagnose and correct any database environment problems; monitor database usage, and report on database performance and system availability.

• Create, modify, and maintain written documentation and modify existing stored procedures, triggers, and views.

Environment: SQL Server 2000 and 2005, Oracle 8i & 9i, VB, ASP, ASP.Net, .Net

• Gyrodata Inc., (November 2002 to September 2005)

Database Administrator / Developer

Installed new MS SQL Server 2000 and maintained 10 to 15 servers. Performed all aspect of database administrator, including data modeling, backup, recovery, and replication. Additionally designed and implemented disaster recovery system. Designed and executing Database Transformation Services(DTS). Wrote Stored procedure and T-SQL code, as well as VB and ASP codes. Also helped develop application and coding in C# environment.

• Monitor MS SQL servers for errors and performance degradation.

• Creating Stored Procedure in T-SQL, Cursor, and Triggers for database functionalities.

• Upgrade existing MS SQL Server software to newer versions and/or Service Pack Levels.

• Set up alerts, operators, SQL Mail, SQL Agent Mail, and notifications.

• Set up and schedule jobs that perform backups and database structure checks.

• Develop reports for different department using SQL Server Reporting Services.

• Created OLAP cubes for SQL Analysis Services.

• Configure Replication, Log Shipping, and Failover clustering to meet customer needs for production environment to development environment.

• Move, transform, and load heterogeneous and homogeneous into SQL Server databases, as well as export SQL Server data to text file and other database systems.

• Define Disaster Recovery and Backup Strategy.

• Helped Developer team in coding with C# and converting COM object to C# level.

• Performed Project lead for job tracking application developed in C#, ASP.Net, and backend with SQL 2000.

Environment: SQL Server 2000 and 2005, Oracle 8i & 9i, VB, ASP, ASP.Net, .Net,C#, C++, COM

• Aramark Food Services, (July 2002 to November 2002)

Application Developer

Responsible for Team co-ordination for the project and delivery of the project. Built web-based applications in ASP, which involved a Search application, Report builder using Crystal Report 8.5 utilities. Wrote Stored procedure and triggers in SQL 2000 for better performance of large query in application. Also created web based reporting application using java, Crystal Report, ASP, and SQL 2000.

Educational Background:

• University Of Houston, Houston, Texas.

MBA in Technology Management (TM & PM) (December, 2010, GPA 3.69) from University of Phoenix

BS in Computer Science (December, 2001, GPA 3.25) from University of Houston

Personal Strengths:

• Highly organized and dedicated, with positive attitude.

• Able to handle multiple assignments under high pressure and consistently meet tight deadlines.

• Thrive on working in a challenging environment.

• Able to work in team and individual.

Contact this candidate