Resume
Objective:
SQL Server DBA with over 9 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, 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:
• Spectra Energy (April 2007 to Present)
Business Intelligence Administrator / Sr. Database Administrator/DW Architect
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 Present)
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.
• 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.
• 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.
• Maverick Consulting Group, Houston, TX (June 2000 to December 2001)
Developer / Database Administrator / Database Programmer / QA:
Responsibilities include designing, implementing, and maintaining the database
system using Visual Basic 6.0, Visual Fox-Pro, ASP, Oracle, Access 2000, MS SQL
Server, PL/SQL, Main Frame, .Net, MS .Net Visual C++, and Crystal Report. Also
establishing policies and procedures pertaining to the management, security,
maintenance, and use of the database management system; and training employees in
database management and use.
Educational Background:
• University Of Houston, Houston, Texas.
BS in Computer Science (GPA 3.25)
Currently enrolled in Master in Computer Science Degree
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.
|
