SUMMARY

• DBA under OS Sun Solaris, DBA under OS HP UX 10000, DBA under Windows NT, AIX
• Programming History of Stored Procedure Application Development.
• Certified Database Administration for, ASE 10.0 - 12.0, Replication Server 11.51.
• Netscape 3.63 Enterprise Server
• Logical and Physical Database Design
• Sybase Database Administration Under Sun Solaris, AIX

PROFESSIONAL EXPERIENCE

Confidential

Sr. Sybase DBA/Replication Server Admin

Responsibilities:

• Replication Server performance and tuning for a diverse mixture of large transactions which are processed by Facets front end that are run on a daily and nightly Tivoli Schedule. Trizetto manages primary database,
• me soley manage teh six replication servers - 12 direct connections to 12 online databases - which feed teh Historical, Reporting, User, and Third Party databases - which tan feed teh Oracle Datawarehouse.
• Day to Day operations include all aspects of maintenance and monitoring teh dataservers, and replication servers.
• Nightly support for development efforts initiated by 4 direct managers, in coordination with various vendors in production, end to end, and sit ongoing on a nightly round teh clock schedule.

Confidential

Sr. Sybase DBA

Responsibilities:

• Support of Production, User Acceptance Testing, and Development environments. Installation of code changes for stored procedures, REP and ASE configuration changes, replication definitions, and subscriptions. Serviced requests from Remedy, and ClearQuest Tracking Systems, Installed source code changes to ClearCase VOBs for Financial applications.
• Extending database segments for future growth.Adhered to strict company compliance policies initiated by Sarbanes-Oxley Act (SOX).
• Performed database refreshes using database dump/restore from production to UAT or Development during off hours. Environments include Sybase Replication Server, Adaptive Server Enterprise, MS SQL Server.
• Analyzing database device allocation for source and target refreshes, if required extended target database device allocations to match production database device size.
• Resolved issues with performance problems using DB Artisan Database Manager, monitoring spids, shared locks, and exclusive lock management.

Confidential

Sr. Sybase DBA

Responsibilities:

• Support of Production, User Acceptance Testing, and Development environments.
• Migration of code changes for stored procedures, replication definitions, and subscriptions.
• Serviced requests from three queues, Support Incident Queue, Change Control Management, and Access Request Forms.
• Delivery and migration of user permissions and privileges via roles for compliance with Sarbanes-Oxley Act (SOX).
• Performed database table level refreshes using bcp for identified tables from production to UAT or Development.
• Tan materialized those tables in teh standby database, using atomic materialization method with hold lock.
• Maintained user server and database access revise user privileges to database objects using scripts and db artisan.
• Developed several reports using shell scripting and transact-sql to populate user tables with permissions for 60+ databases, used these tables to query against and generate group permissions counts, cumulative daily totals, and day by day.
• Grant/revoke teh privileges to teh groups, extract and restores.
• Database object Auditing
• Managing user permissions
• Managing ASE logins and database users
• Configuring client/server char sets
• Configuring sort orders
• Diagnosing Systems Problems
• Security Administration
• Developing backup and recovery plans
• Restoring user databases
• Initializing database devices
• Setting database options
• Creating and managing user databases
• Creating and using segments
• Setting up table locking schemes
• Remote procedure calling
• Troubleshooting object privilege requirements using roles, public group, and user defined groups.
• Many other aspects of troubleshooting in ASE, and Replication Server.

Confidential, MN

Sr. Sybase DBA

Responsibilities:

• Support of Production, and Quality Assurance Testing.
• Sorbane Oxleys compliance testing and reporting for 150 dataserver, and 400 databases.
• Database backup and recovery testing of databases and applications using Legato.
• Adding, and extending disk LU allocations using veritas volume manager for database target locations.
• Analysis and implementation of user permissions and privileges via roles for compliance with Sarbanes-Oxley Act (SOX).

Confidential, NJ

Sr. Sybase DBA

Responsibilities:

• Implementing Security for application users using groups and roles within ASE for legacy applications. Review teh outstanding database user list, determine which users are no longer valid.
• Eliminate teh invalid users. Review teh applications functionality, identify and map tables to application functions. Determine which DML commands are used by teh group for application functionality.
• Grant/revoke teh privileges to teh groups. Refine teh user list, and assign teh users to teh appropriate group by job specification. Review all T-SQL stored procedures across 40 databases, for a total of 4000 stored procedures.
• Document, Analyze, and describe high-level existing issues with teh procedures. Make recommendations to address teh existing performance issues.
• Prove teh recommendations provide a significant benefit. Construct proof by extracting millions of records from production data to QA and obtaining baseline performance criteria.
• Use teh baseline statistics to compare with teh statistics generated from implementing teh recommended changes.
• Organize teh results, categorize teh issues, and present/convey this details in departmental meetings to be critiqued by teh development team.
• Reviewed teh recommendations, and arrived at teh recommendation to teh development team.
• Contruct a best practices document, using MS Word to convey detailed TSQL/Optimizer concepts to teh development team.

Confidential, NJ

Sr. Consultant,

Responsibilities:

• Checking teh index statistics, or
• A where clause is causing teh optimizer to select an inappropriate strategy, or
• Teh rows that will be referenced by a given transaction do not fit teh pattern reflected by teh index statistics, or
• No appropriate index exists for a critical query.
• Review teh contents of teh tables being queried and other factors such as cache strategies cache sizes, and me/O size.
• Performance Tuning at teh application layer involvement
• Developing a backup and recovery schemes, full backs, and incremental backups periodically.
• Distributing teh storage of data across devices
• Limit auditing of objects which affects performance; audit only wat you need
• Scheduling maintenance activities during off peak hours, as this can slow performance and lock users out of tables

Confidential

Repserver Manager.

Responsibilities:

• Using SQL, teh heavy use of cursors, and stored procedures, designed a process to automate teh manipulation of teh data from flatfile format to an intermediate format into table structures.
• Data Modeling Tool, used "Power Designer SQL Modeler" to build and maintain teh logical and physical representation of schema's, tables, indexes, triggers, stored procedures, constraints and defaults.
• Project Management Software, used "MicroSoft Project" to manage teh time allotted to develop project components and manage teh time requirements per task.
• Teamed with client to approve and develop project schedule and task list to track and guide teh progress vs hours logged on teh project.
• Developed shell/korn scripts to start teh process, and clean up before and intermediate files on disk partition.
• Developed scripts to backup project directory under unix to tape.
• Installation and configuration of ASE 11.5, and of Replication Server.
• Performance test and tune stored procedures developed during teh development phase.
• Created tables, indexes, and stored procedures.
• Developed stored procedures to implement teh new data model.
• Wrote shell scripts to dump and load teh database to disk and to tape using cron.

Confidential

Sr. Sybase Database Administrator

Responsibilities:

• Developing strategies, policies, standards, and procedures for teh Sybase environment.
• Monitor and adjust database transaction activity and device and object storage.
• Ensured data security.
• Ensure data consistency by maintaining referential integrity rules.
• Design and perform database backup and recovery strategies.
• Translate logical data designs into physical database designs using scripts and or GUI.
• Maintained physical database structures using isql, korn, and bourne shell scripts.
• Support disaster recovery planning and testing by periodically loading incremental dumps.
• Performance and Tuning of Sybase Server objects for fund investment application for CIBC.
• Developed maintenance tasks in development, and provided database production support.
• Performed change management tasks using PVCS, and SCCS to track object modifications.