Summary

More than Fifteen years of experience in IT Management, Database Administration, Systems Administration, ITIL best practices, implementation and maintenance of systems in 24 7 environments.

Confidential

Responsible for all IT infrastructure and Data Center operations, consisting of 120 windows servers, 10 SOLARIS servers, Oracle and SQL database clusters, desktops and Citrix XenApp thin clients, SAN Storage, Applications customizations and supporting about 1200 users in a 24 7 manufacturing environment.

I am currently leading the Storage and Backup team for Baxter Manufacturing facilities across facilities.

VMWARE:

Implemented VMWare ESX 5.5 using Hitachi HUS 150 for storage and used VEEAM 7.0 for backup. We are currently migrating physical machines to virtual. Designed and configured storage for other facilities within Baxter Irvine CA, Cartago Costa Rica , Tampa FL and Mexico. These other locations are using Hitachi HUS 110 for their storage.

Helpdesk Improvements:

Within six months of managing the help desk team, achieved SLA goals for all help desk tickets. The goal was achieved by conducting daily stand up meetings, monitoring help desk trends, heavy following up with technicians, distribution of work load and motivating technicians to learn newer technologies.

Compliance:

SOX policies were implemented and maintained for ERP application, Operating systems and for databases. SOX audits were completed without any major findings. CFR Part 11 compliance was also maintained for all the systems that were installed and maintained.

Change Control:

Established change control policies and procedures. Coordinated change control meetings, to ensure that best practices are being followed.

On-Call Management:

Established procedures and escalation guidelines for on-call responsibilities, Manage on-call rotation and act as tier 2 3 escalation support.

Responsibilities:

• Supervise daily tasks and project progress of team members.
• Review individual goals for the year, conduct periodic and yearly performance reviews, and recommendations for merit increases.
• Manage Software and Hardware Licenses
• Manage all aspects of data center including security, air and power.
• Change management approve, review and installation
• Incident Management reviews and resolution for all infrastructure systems.
• On-Call review and root cause analysis
• Forecast and manage yearly IT budget
• Establish and publish Key Performance Indicators to measure and communicate departmental performance.
• Direct research on potential technology solutions in support of procurement efforts.

Manage network infrastructure

• Consult with users, management, vendors, and technicians to assess computing needs and system requirements Prioritize projects and follow SDLC in implementing
• Update all IT policies and procedures, including those for architecture, security and standards.
• Ensure service levels for system availability for mission critical systems and applications
• Ensure team members are cross-trained and that support is available for all applications
• Design Hardware specifications and capacity planning for databases
• Maintain relationship with Software and Hardware Vendors, Negotiate and administer vendor, outsourcer, consultant contracts and Service agreements
• Oversee IT hardware/ software management, including maintenance of component inventory and related documentation.
• Implementing and maintaining Sarbanes-Oxley policies 404 document .
• Ensure that all applications are CFR Part 11 compliant
• Proactive monitoring of Systems using What's up Gold
• Apply all critical patches to servers
• Manage financial aspects of the IT Department, including purchasing, budgeting, and budget review
• Ensure efficient and effective management and delivery of help desk services
• Recruit, hire, train and supervise staff, or participate in staffing decisions

Sr. DBA and Systems Administrator

• As a Senior DBA in Providian Financial I supported the databases in Oracle for Under Writing, Sales Balance Transfers, New Credit Cards, and Credit Card Products , Customer Risk Management and Collections applications, which had up to 4000 user connections and databases ranging from a few MB up to 500GB. Supported Data marts in Oracle 9i. The data marts are from 300 GB to 1.2 TB in size. These were vital databases that supported the organization. The databases in Sybase were either converted to Oracle or redesigned.
• Accomplished increased throughput and reduced backup time window by additions to the tape libraries and adjusting the backup schedule. Created check lists to make sure all the systems are being backed up. New procedures were created for testing backup and restore.
• LIMS system was implemented using Veritas Cluster Server for oracle on Solaris. Oracle database, Veritas Cluster and Solaris Servers were installed and configured for SQL LIMS application.
• Managed and lead the implementation of DSI version 5. Performed hardware analysis, configuration, procurement and end user training on hand held computers for scanning bar codes .
• complete on time and within budget. The various tasks completed were creating the upgrade proposal, budget, technical project plan, and development coordination, hiring of contractors to support development, user-testing, project management and completed all CNC administrator tasks for the upgrade.
• Uptime and Availability of all critical systems was increased by implementing Veritas 5.0 Cluster Server for Oracle. Designed, Procured and implemented the system. The system was installed on Sun m4000 servers using HP EVA4400 as SAN Storage.
• Change control management
• Logical and physical modeling for new development
• Participate in the complete SDLC of the project with the team and manage database administration projects.
• Organize and assign specific tasks for each team member.
• As Systems Analyst, I Manage the deployment, monitoring, maintenance, development, upgrade, and support of all IT systems - Servers, PCs, operating systems, hardware, software, and peripherals following ITIL best practices.. The applications supported are JDEdwards ERP System , DSI dclink, SQL LIMS, TrackWise, Documentum, Intranet and Laboratory and manufacturing and environment monitoring systems.
• Capacity planning for production databases
• Provide Technical consultation to the development team.
• Write annual review for team members.
• Implement Standards and maintain the DBA best practices guide
• Interview candidates for DBA and Data Modeling Team
• Conduct Business Resumption exercise
• Design and document Oracle monitoring parameters for Patrol implementation
• database administration tasks, design and develop supporting applications, maintain and develop new stored procedures, improve performance on Database operations. Designed and developed an application for Membership information, which was received weekly from Signature parent organization using Visual Basic to process the tape data and update the SQL Server database.
• As a Client/Server consultant worked on various projects for Compuflex International, using Sybase 10.0, PowerBuilder 4.0, Sybase Open Server/Open Client and ERWin. Designed and developed database model for Affiliate Information management System AIMS for fx Network Inc. a division of 20th Century Fox. An OpenServer application was developed to communicate with IBM3270 terminal for a client. OpenServer was used to transfer data from Sybase database to 3270 terminal and emulate the functions performed on the 3270 terminal using SUN Link 3270 HLI application programming interface.
• Developed an automation interface between SmarT Tele Sales and Marketing system and CoSMOS Corporate Sales, Marketing and Operations System . The data was thoroughly analyzed to ensure transfer of correct data from SmarT to CoSMOS. DB-Library C programs were developed to transfer data
• Worked as a developer on Sybase 4.2 developed user Interface for Employee database and payroll for the organization. Developed stored procedures and triggers to improve performance.