Manager Sql Server
Resume:
Grant Blair
Senior Sybase Database Administrator
Summary:
** ******* **** ***** ** 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.
13 Maintained, installed and upgraded Sybase Database and Sybase Replication Servers, Setup
disaster recovery procedures.
14 Conducted performance and tuning on Sybase database system using internal and external
database and system tools.
15 Designed and maintained Logical and Physical Database structures using Erwin, ER Studio, and
Power Designer. (Tapes offsite, replication), etc.
16 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
17 Provided 24/7 support on Production Database System, developed and designed front end
applications using Power Builder, managed full product life cycle.
Technical Skills:
Support: SQL Database, MVS Database, PC and Notebooks, Application Development
and
Upgrades, Platinum and Tivoli Case tools
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.
Professional Experience:
Hewlett Packard, Roseville, Sacramento, CA
July’2003 – Present
Database Administrator Oracle DBA, Sybase DBA, Replication Administration
Responsibilities:
18 Assisted in providing expertise to the development teams in the design and development of
production, test, and development enterprise Sybase (12.5.3) and Oracle (9.2.0.1) Servers and
databases.
19 Provided production level Management while supporting current and future database development
and methodologies.
20 Proactively evaluated physical and logical design of databases to keep up with the dynamic and
growing business needs in an e commerce environment.
21 Often contributing to team architect in the development and design of a corporate enterprise data
warehouse.
22 Responsible for Leading in the design of logical and physical databases.
23 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.
24 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.
Titan Systems, Maryland
July’2002 – July’2003
Clients: Lockheed Martin / Naval Air Defense
Senior Database Administrator Sybase, Oracle, MS SQL Server & DB2
Responsibilities:
25 As a Sybase Database Administrator, provide Production Support and Performance Tune on
production systems.
26 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.
TBCI Contract Services, Los Angeles, CA Feb’2000 –
July’2002
Senior Database Administrator Sybase
27 Subcontractor to Dresdner Global Investor Oracle, Sybase, MS SQL, DB2
28 Subcontractor to AT&T wireless services Replication Administration
29 Subcontractor to Sun Microsystems Business Analyst
Responsibilities:
30 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
31 Interviewing employees at all levels within the organization and participating in meetings to
discuss projects and milestones.
32 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
33 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.
34 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
EDP Contract Services, Dallas, TX
Mar’1995 – Feb’2000
Database Administrator – Sybase & Oracle
35 Subcontractor to IBM Replication Administration
36 Subcontractor to Viag Intercom/Benz Sybase and Oracle Admin
37 Subcontractor to Texas Workforce Comm. Business Analyst
38 Subcontractor to Texas Instruments DB2 on MVS admin
39 Subcontractor to Texas Department of Transportation DB2 on MVS admin
Responsibilities:
40 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.
41 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.
42 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
1) Business process flows,
2) Software requirements specifications,
3) Business requirements, including data elements,
4) Business rules,
5) Non functional specifications,
6) Use case details,
7) Use case level activity diagrams from platinum case tools.
43 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.
44 Performance tuning Oracle 8i, reorg, indexes rebuilds, check database instances, memory,
number of user, etc.)
45 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.).
46 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
47 Documentation of new implementation
Environment: HP UX, System XI Client / Server, Sun Solaris (Veritas Volume Manager, NetBackup)
The Office of the United States Trustee, Austin, TX
Apr’1991 – July’1995
Sybase DBA
Responsibilities:
48 Implement Backup and Recovery (automate database backup using shell scripts and cron jobs,
develop a disaster and recovery plan (tapes offsite, replication), etc.).
49 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).
50 Monitor and Maintain Peoplesoft databases (start and check application and database schedulers
are running, add tables, databases and indexes, work with developer team.
51 Troubleshoot SQL and stored procedures (redesign and implement preexisting procedures),
Provide DBCC and Update Stat Monitoring (checks memory allocation and rebuilds indexes).
52 Created stored procedures and triggers, backups and recovery on MSSQL Server. Established
connection to database via Open Client and ODBC, Gateway Setup.
53 Connecting from Access database with an ODBC Gateway Connection to SYBASE database.
54 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:
55 Bachelor of Science, May 1991, National State University, Concentration: Information Systems
and Computer Science
Professional Training:
56 NT Server (Certificate)
Texas Workforce Commission 1995 Microsoft Training Center, Seattle,
WA
57 MVS/DB2 System Database
DB2 (JCL) BMC Tools 1996 Texas Workforce Commission,
Austin, TX.
SYBASE 1995 1998
58 SYBASE (Fast Track, Certificate); Sybase Training Center
59 SYBASE (introduction to SQL for System II, Certificate); Dallas, TX
60 SYBASE (Server Administration, Certificate)
61 SYBASE (Advanced Server Administration, Certificate); Sybase Training Center
62 SYBASE (Performance Tuning, Certificate); Emeryville, CA
63 SYBASE (Replication Server, Certificate)
64 SYBASE (Internals, Certificate)
65 SYBASE (Replication Server Disaster Recovery, Certificate); Sybase Training Center
66 SYBASE (Advanced Replication Server, Certificate); Bethesda, DC
Contact this candidate