Senior Database Administrator

Summary:

• Fifteen plus years of solid Sybase Database Administration and related programming experience, over seven years of Unix experience that includes Solaris, HP-UX, and AIX, over five years of experience with Sybase Replication and related activities, over three years of Oracle Database Administration, design/data modeling, over two years of experience with Mainframe related programming that includes DB2, over 4 years of UDB DB2 and Hands on experience with People Soft, over seven years of MSSQL Server on NT.
• Maintained, installed and upgraded Sybase Database and Sybase Replication Servers, Setup disaster recovery procedures and XML Order Documents and SQL.
• Conducted performance and tuning on Sybase database system using internal and external database and system tools.
• Designed and maintained Logical and Physical Database structures using Erwin, ER Studio, and Power Designer. (Tapes offsite, replication), etc.
• Provided support to Engineering and QA groups, setup and maintained Data Warehousing Servers, performed database recovery and backup, monitored database error logs and disk space usage, developed database monitoring and maintenance procedures using Unix scripting language, developed and maintained triggers and stored procedures, developed methodology to move data across various database platforms, provided users with T-SQL, SQL, and database support Provided 24/7 support on Production Database System, developed and designed front-end applications using Power Builder, SQL Builder, HipLink, MQSeries
• Managed full product life cycle.

Technical Skills:
Database: Sybase IQ, DB2 UDB, DB2 for MVS, SQL Plus & PL/SQL Crystal Reports, IMS, DBCC Driver, Sybase and ASE 10, 11, 11.3.x, 11.5.x, 11.9.2, 12.0.x, & 12.5.x Sybase Replication Server 11.0 & 11.5.1, & 12.0.x Oracle 8x, MS SQL Server 6.5 & 7.0, Sybase, SQL Anywhere, Access and SQL language
OS: MVS, HPUX, SUN SOLARIS 2.6/5.6, DOS, Windows 95, UNIX, OS/2, Novell, and Windows NT Professional
Languages: C, C++, VISUAL BASIC, COBOL, Power Builder 5.0, 6.5 & 7.0, UNIX scripting, Perl.
Tools: DB Artisan, Erwin, ER Studio, Power Designer, SQL Backtrack, Tivoli, And Clear Case, Informatica V8.6.
Support: SQL Database, MVS Database, PC and Notebooks, Application Development, SQL Builder, HipLink, MQSeriesand Upgrades, Platinum and Tivoli Case tools

Professional Experience:

Confidential, Roseville, Sacramento, CA July'2003 - Present
Database Administrator - Oracle DBA, Sybase IQ, Sybase DBA, Replication Administration

Responsibilities:

• Assisted in providing expertise to the development teams in the design and development of production, test, and development Sybase IQ, enterprise Sybase (12.5.3) and Oracle (9.2.0.1) Servers and databases.
• Provided production level Management while supporting current Mapping between XML and SQL and all three basic ways to store XML data in SQL, for which we use the terms element storage, document storage, and hybrid storage..
• Proactively evaluated physical and logical design of databases to keep up with the dynamic and growing business needs in an e-commerce environment.
• Often contributing to team architect in the development and design of a corporate enterprise data warehouse.
• Responsible for Leading in the design of logical and physical databases.
• Support and Identifying architectural issues and propose alternative solutions and providing data access using Informatica V8.6 and other methods for business objects utilizing the latest server technologies. Developed databases to support server based applications using UNIX shell script and Perl scripts. Other responsibilities included designing maintenance plans, Evaluating and monitor databases to resolve performance issues, determine resource consumption estimates and recommend system upgrades, Interpret business requirements to develop data entity structures and star schemas, Maintain (Development and Test) Oracle and Sybase Server databases in the Management Information environment, Develop application/inter-application test plans assist in the development data requirement test scenarios, verify test results, Install upgrades and patches to existing databases. Effectively administer an Sybase IQ (Simplex or Multiplex) Choose the correct Sybase IQ index types Create Sybase IQ databases, tables, and indexes Load data into Sybase IQ from a variety of sources Create and load join indexes Backup and restore a Sybase IQ database Monitor and troubleshoot a Sybase IQ installation Learn performance and tuning techniques for Sybase IQ
  

Responsibilities:

• As a Sybase Database Administrator, provide Production Support and Performance Tune on production systems.
• Installing Development Support systems, Replication, and Application Support by redesigning Query plans, stored procedures, triggers for government application (VFS, AMES, TERADATA), Managing Replication Server System, Primary and Replication Adaptive Server database, Replication Server System Database (RSSD) (Replication Server system tables). Replication agents, Stable queues, Routes, Subscriptions and Warm Standby.

• Subcontractor to Dresdner Global Investor -Oracle, Sybase, MS SQL, DB2
• Subcontractor to AT&T wireless services -Replication Administration
• Subcontractor to Sun Microsystems -Business Analyst

Responsibilities:

• Task included Production Support, Performance Tune and Upgrade Sybase Server versions (11.9 - 12.5), Upgrade Sybase Replication Server and Backup Server versions (11.9 - 12.5), Informatica Application, Install Oracle version (8i), Install MSSQL Server, Database Data Modeling (Erwin, Power Design), Database Relational DB Design, Install DB2 UDB, Implement Backup, Recovery cron jobs, develop tablespace and recovery plan replication from Sybase to DB2 via Direct Connect, Client/Server Testing, Visual Basic application on Access Database, Production Support Microsoft SQL Server, Operating Systems: NT, Unix on Sun (Veritas Volume Manager, NetBackup) and Unix on HP, Coordinate system implementation, Internet Systems Process Modeling, Feasibility Assessments, Technical Software Specifications, Object Oriented Analysis Project Management, Technical Writer/Instructional Design Documentation, Technical Writing, Client/Server Testing, CGI performance/intergration
• Interviewing employees at all levels within the organization and participating in meetings to discuss projects and milestones.
• Participates in meetings/team activities to identify project goals and ensure guidelines detailed by the Project Management Office, prepare project implementation steps and document appropriately System
• Development Process including requirement gathering and testing, identification, design, development and Implementation of systems related projects, Documentation of new implementation using Platinum and Tivoli Case tools, editing using the awk Programming Language and Stream editing (sed) Shell scripting.
• Create and Automate Shell scripts for Implementation and maintenance.

Environment: NT, HP-UX, System XI Client / Server NT, SUN SOLARIS (Veritas Volume Manager, NetBackup), System XI Client / Server

• Subcontractor to IBM -Replication Administration
• Subcontractor to Viag Intercom/Benz -Sybase and Oracle Admin
• Subcontractor to Texas Workforce Comm. -Business Analyst
• Subcontractor to Texas Instruments -DB2 on MVS admin
• Subcontractor to Texas Department of Transportation -DB2 on MVS admin

Responsibilities:

• Ability to work as a mainframe Database Administrator for real time data collection (MVS System Database) Mitron System Support, IMS System Support and DB2 Real Time Data Collection Support, while maintaining primary experiences including Migrating from Sybase 11.3.0 to Y2K compliant versions (11.3.3 and up), Migrating from Access Database using Visual Basic to Sybase, Manipulating and storing data in a Data Warehouse using Sybase IQ, Supporting Groups in Application Development and Y2K, Building from ground up with system maintenance and upgrades.
• Automating Remote backups and other maintenance (DBCC and update statistics), BCP, Bulk Copy Sybase table data, The awk Programming Language and editing, Stream editing (sed) Shell scripting and data manipulation, Production Support Sybase 11.3.0 and 11.9.2, Upgrading Sybase from version 11.3.0 to 11.9.2, Upgrading Peoplesoft from version 6.02 to 7.5 HR, Payroll and Benefits Administration, Functional knowledge transfer plus support project team through upgrade, Sybase as the database server for Peoplesoft, Converting Peoplesoft SQR and SQC into Sybase stored procedures.
• Define required parameters for database definition, Analyze data volume and space requirements, Perform database tuning and parameter enhancements, Execute database backups and recoveries, Monitor database space requirements, Verify integrity of data in databases, Produce documentation from this business analysis phase. The deliverables are
• Business process flows,
• Software requirements specifications,
• Business requirements, including data elements,
• Business rules,
• Non-functional specifications,
• Use case details,
• Use case level activity diagrams from platinum case tools.
• Other related requirement are Performance tuning - Sybase 11.03 (sp_sysmon, relational rules, rebuilding indexes (update statistics), Flexi, CW, AMD, providing Production support (respond to active database problems, communicate with manager and developer with critical response), providing replication Support (create repdef, routes, repagents) monitoring repagents or LTMs, monitoring Latency and transaction logs. Create Stable devices, performing Sybase backups using SQL Backtrack - Performing transaction load and recovery, performing Replication Installations of repdef and LTMS, monitoring routes, Performance tuning Latency and transaction logs, Monitoring Stable cues.
• Performance tuning - Oracle 8i, reorg, indexes rebuilds, check database instances, memory, number of user, etc.)
• Also Provide Production support on MSSQL Server (respond to active database problems, communicate with manager and developer with critical response, debug SQL and application reports, provide most efficient procedures, check error log, check backups and scripts, perform updates, implementation and data migrations, etc.).
• Application support included Installs Kenan Application and databases while Providing Production Support and maintaining the databases and bringing system on-line. Overall Business Analyst working with case tools
• Documentation of new implementation

Environment: HP-UX, System XI Client / Server, Sun Solaris (Veritas Volume Manager, NetBackup)

Confidential, Austin, TX Apr'1991 - July'1995
Sybase DBA

Responsibilities:

• Implement Backup and Recovery (automate database backup using shell scripts and cron jobs, develop a disaster and recovery plan (tapes offsite, replication), etc.).
• Develop Loan System (Develop server and Databases using tools (Erwin, Power Designer) in third normal form, denormalize databases, reverse engineer databases, BCP data, develop stored procedures and scripts, test, develop, production).
• Monitor and Maintain Peoplesoft databases (start and check application and database schedulers are running, add tables, databases and indexes, work with developer team.
• Troubleshoot SQL and stored procedures (redesign and implement preexisting procedures), Provide DBCC and Update Stat Monitoring (checks memory allocation and rebuilds indexes).
• Created stored procedures and triggers, backups and recovery on MSSQL Server. Established connection to database via Open Client and ODBC, Gateway Setup.
• Connecting from Access database with an ODBC Gateway Connection to SYBASE database.
• Support included working as Server Support, Programmer Support, and Engineering Support, NT workstations (front end users) and servers, ODBC Drivers, using SQLNET for Crystal Reports and Open Client for SYBASE Programming in Client/Server C, Client/Server C++, Network Data Communications Messaging Product and Technical Knowledge

Environment: DB2, SYBASE, ORACLE, MVS, ACCESS, NATURAL, PREDICT, JCL, BMC Utilities, File-Aid for DB2, Cognos Impromptu on SYBASE, SQL, SYBASE SQL Server Manager, Power Designer, DBartisan, Visual Basic, NT Server 4.0 (training and certification), and Provided technical Phone support, Sun Solaris (Veritas Volume Manager, NetBackup)

Education:

• Bachelor of Science.
  Concentration: Information Systems and Computer Science

Professional Training:

• NT Server (Certificate) Confidential, Seattle, WA
• MVS/DB2 System Database DB2 (JCL) BMC Tools 1996 Confidential, Austin, TX.
  SYBASE 1995-1998
• SYBASE (Fast Track, Certificate) Confidential
• SYBASE (introduction to SQL for System II, Certificate) Dallas, TX
• SYBASE (Server Administration, Certificate)
• SYBASE (Advanced Server Administration, Certificate) Confidential
• SYBASE (Performance Tuning, Certificate) Emeryville, CA
• SYBASE (Replication Server, Certificate)
• SYBASE (Internals, Certificate)
• SYBASE (Replication Server Disaster Recovery, Certificate) Confidential
• SYBASE (Advanced Replication Server, Certificate) Bethesda, DC