Bridgewater, New Jersey, United States
IT Manager with experience in the pharmaceutical, Telecommunication and Financial industries. Proven track record in the areas of database engineering, architecture and design, operations, and application development. Currently managing a global team of DB2 LUW/DB2 Connect staff, responsible for supporting multiple lines of business for a large financial firm. Provide hands-on support when required. Excellent communication and presentation skills.
• Manage global team of DB2 LUW/DB2 Connect staff, responsible for supporting multiple lines of business. • Designed and implemented DPF and Non-DPF DB2 databases supporting core business applications. Develop architecture solutions complied with business requirements. • Led team supporting installations, upgrades, maintenance, power-downs, and disaster recovery. Responsibilities focus on database design and implementation, performance monitoring and tuning, quality assurance testing and troubleshooting production problems. Major functions included logical modeling, physical database design, database creation and migration, backup/recovery, capacity planning, storage layout and management, production implementation and disaster recovery. • Managed major infrastructure projects including business continuity testing, database security and DB2 Connect engineering and integration. • Review production support procedures to improve availability, integrity, and performance. • Automated scripts to monitor databases and report issues, review and tuning of instance configuration/settings and SQL, and enforcement of database security.
Responsibilities: • Perform database maintenance activities such as backup, reorg, runstats. • Install and configure DB2 UDB new releases, upgrades, and patches. • Scripting, design/analysis, installation, monitoring, maintaining, troubleshooting, and tuning LUW databases • Analyze DB2 UDB Event Monitor information, physical design, performance characteristics of tablespaces, physical I/O rates, and table access activities. • Proactively monitor performance, diagnose problems and tune queries and database. • Assisting with the creation and modification of primary database storage structures (tablespaces) and primary objects (tables, views, indexes) • Implement data security guidelines while making data available to those authorized to have access • Create and maintain documentation such as functional design documents, detailed design documents, data flow diagrams, data entity relationships documents • Interface with business analysts & developers with regards to application, logical & physical database design, create and maintain logical entity relationship diagrams, transform logical models into physical data models. • Changing instance level and database level configuration parameters for database concurrency, authentication, performance and allowing remote clients accessing server. • Provide 24X7 on-call support • Perform capacity planning and analysis
Responsible for the design, development, enhancement and support of the Information Technology Center (ITC) Business system (BIS). The system provides the ITC’s management and planners with hardware and software configurations, budget development, and reporting capabilities in support of its $100 million annual budget. Duties include all call-level support, DBA operations, development and testing of new software. Environment: MVS, PL/1, DB2, FOCUS, SAS, TSO/ISPF, Powerbuilder, “C”, Perl, CGI, JavaScript, HTML, Solaris, IBM HTTP Web Server Responsible for DB2 UDB (EE) production servers running on Sun Solaris machines. Duties include installation, query and stored procedure development, troubleshooting, recovery planning and implementation, database performance monitoring and tuning, and providing database-related assistance to developers.
Responsible for the design, development, enhancement and support of the Information Technology Center (ITC) Business system (BIS). The system provides the ITC’s management and planners with hardware and software configurations, budget development, and reporting capabilities in support of its $100 million annual budget. Duties include all call-level support, DBA operations, development and testing of new software. Environment: MVS, PL/1, DB2, FOCUS, SAS, TSO/ISPF, Powerbuilder, “C”, Perl, CGI, JavaScript, HTML, Solaris, IBM HTTP Web Server Responsible for DB2 UDB (EE) production servers running on Sun Solaris machines. Duties include installation, query and stored procedure development, troubleshooting, recovery planning and implementation, database performance monitoring and tuning, and providing database-related assistance to developers.
Supervised 4-5 SAS programmers. Responsible for the design, development, and maintenance of clinical reports and statistical files for new drug applications submitted to the FDA • Worked closely with team Statistician and prepared adhoc reports for analysis • Wrote SAS programs to generate tables, listings, figures, and analysis datasets in support of Clinical Study Reports and other regulatory submissions • Created SAS programs to load data from raw data files in different formats and conduct data checking, data cleaning, data validation.