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 the six replication servers - 12 direct connections to 12 online databases - which feed the Historical, Reporting, User, and Third Party databases - which then feed the Oracle Datawarehouse.
• Day to Day operations include all aspects of maintenance and monitoring the dataservers, and replication servers.
• Nightly support for development efforts initiated by 4 direct managers, in coordination wif various vendors in production, end to end, and sit ongoing on a nightly round the 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 wif 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 wif Sarbanes-Oxley Act (SOX).
• Performed database table level refreshes using bcp for identified tables from production to UAT or Development.
• Then materialized those tables in the standby database, using atomic materialization method wif 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 wif permissions for 60+ databases, used these tables to query against and generate group permissions counts, cumulative daily totals, and day by day.
• Grant/revoke the privileges to the 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 wif Sarbanes-Oxley Act (SOX).

Confidential, NJ

Sr. Sybase DBA

Responsibilities:

• Implementing Security for application users using groups and roles wifin ASE for legacy applications. Review the outstanding database user list, determine which users are no longer valid.
• Eliminate the invalid users. Review the applications functionality, identify and map tables to application functions. Determine which DML commands are used by the group for application functionality.
• Grant/revoke the privileges to the groups. Refine the user list, and assign the users to the 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 wif the procedures. Make recommendations to address the existing performance issues.
• Prove the recommendations provide a significant benefit. Construct proof by extracting millions of records from production data to QA and obtaining baseline performance criteria.
• Use the baseline statistics to compare wif the statistics generated from implementing the recommended changes.
• Organize the results, categorize the issues, and present/convey dis details in departmental meetings to be critiqued by the development team.
• Reviewed the recommendations, and arrived at the recommendation to the development team.
• Contruct a best practices document, using MS Word to convey detailed TSQL/Optimizer concepts to the development team.

Confidential, NJ

Sr. Consultant,

Responsibilities:

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

Confidential

Repserver Manager.

Responsibilities:

• Using SQL, the heavy use of cursors, and stored procedures, designed a process to automate the manipulation of the data from flatfile format to an intermediate format into table structures.
• Data Modeling Tool, used "Power Designer SQL Modeler" to build and maintain the logical and physical representation of schema's, tables, indexes, triggers, stored procedures, constraints and defaults.
• Project Management Software, used "MicroSoft Project" to manage the time allotted to develop project components and manage the time requirements per task.
• Teamed wif client to approve and develop project schedule and task list to track and guide the progress vs hours logged on the project.
• Developed shell/korn scripts to start the 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 the development phase.
• Created tables, indexes, and stored procedures.
• Developed stored procedures to implement the new data model.
• Wrote shell scripts to dump and load the database to disk and to tape using cron.

Confidential

Sr. Sybase Database Administrator

Responsibilities:

• Developing strategies, policies, standards, and procedures for the 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.