Resume of Database Administrator

Title
Database Administrator

Primary Skills
SQL Server, Oracle, .NET, VB6

Location
US-CT-Stamford (will consider relocating)

Posted
Apr-01-08


SUMMARY OF QUALIFICATIONS:
• Over TWELVE years of IT experience out of which EIGHT years of extensive experience in Database Administration, Implementation and Development for the use of integrating applications.
• Expert in Databases Administration, Management using RDBMS such as SQL Server and Oracle under UNIX and WINDOWS environment.
• Extensive DBA experience in supporting over a hundred SQL Server instances comprising of versions (2005/2000/7.0/6.5) and several hundreds of databases on a 24x7 production environment in a clustered (active-active/active-passive) or non-clustered builds.
• Strong knowledge in SQL Server disaster recovery, backup/restore, migration, and upgrade.
• Strong understanding of SQL Server best practices and ability to recommend corporate wide SQL Server standards, I/O subsystem planning and RAID configuration, sizing, capacity planning.
• Experience in Software development mainly in modern web technologies, server-side, client-side and database interfacing (VB6, ASP, VB.NET, C#).
• Strong DBA development skills writing TSQL/PLSQL scripts, creating DTS, SSIS.
• Strong scripting skills using PERL, SHELL, VB script and DOS batch scripts.
• Strong understanding of Windows system administration, installation, security, user management, networking, disk configuration.
• Capable of working under pressure and stiff deadlines, ability to drive change.
• Ability to document implementations and write scripts as per SOX standards and change management
• Good team player and ability to mentor.

MS SQL Server 2005 Platform:
• Administration including Planning, Installation, Deployment/Implementation, Advanced Configuration of MS SQL Server 2005 in a clustered/non-clustered environment, Log shipping, Database Mirroring, Database snapshots
• Upgrade/Migration of MS SQL Server 2000 to MS SQL Server 2005 using any suitable approach (in place or side by side).
• Database maintenance plans using SSMS or BIDS, creating SSIS Packages
• User and database security management, creating groups, users, roles, granting permissions, policies.
• Using SQL Server Profiler and other tools for trace Analysis.
• On going skill upgrade on MS SQL Server 2005 in various technical areas.

MS SQL Server 2000/7.0 Platforms:
• Administration including Planning, Installation, Deployment/Implementation, Upgrade/Migration, Advanced Configuration of MS SQL Server 2000/7.0
• Use of Native tools like Performance Monitor, Profiler and External Tools like Quest Spotlight for Performance Monitoring and Tuning of MS SQL Server 2000/7.0 residing databases on SAN storage.
• Set up SQL Server Databases in a lab environment and duplicate the functionality of the SQL Server in Development, Test/Acceptance and Production environment.
• Backup/restore, disaster recovery using native SQL Server commands and Veritas Net backup.
• Service pack installation and hot fix application strategies
• Administration of OLTP environment with Extraction Transformations and Loading (ETL) using DTS packages or customized VB6/vb scripts, DOS batch scripts
• Configuration and Importing Data from Oracle 8i/9i/10g Server (or other data sources) to MS SQL Server 2000 using Linked Servers on OLE DB Provider and Data Transformation Services (DTS).
• Planning, administration, and implementation of Snapshot, Merge, and Transactional Replication of MS SQL Server Databases, successfully configured/administered transactional replication using MS SQL Server 2000.
• Planning, implementation and administration of Log Shipping with MS SQL Server 2000.
• Installation/administration of Cluster Servers for MS SQL Server 2000 Enterprise Edition hosted on MS Windows 2000/2003 Advanced Server.
• Experience in Configuration of Web Servers using IIS 6.0/5.0 and integration of MS SQL Server


? MCP - Installing, Configuring and Administering Microsoft® SQL Server? 2000 Enterprise Edition.
? MCP - Managing and Maintaining a Microsoft Windows Server 2003 Environment.
? MCP - Developing and Implementing Web Applications with Microsoft® Visual C#? .NET and Microsoft® Visual.
? www.brainbench.com - Linux Administration, MySQL 3.23 Administration, RDBMS Concepts, HTML 3.2


TECHNICAL SKILLS:
Prog Languages: SQL (T-SQL/PL/SQL), ASP, Perl, CGI/DBI/DBD/mod_perl, VB.NET/C#, ASP.NET, ADO.NET, VB6, VBScript, Javascript, HTML, OOP, COM/DCOM, UNIX shell scripting (Bourne/Kourne shell), PHP4, Java, XML, C/C++.
Operating Systems: WinXP/95/98/Me/3.11, Win2003/2000/NT, SunOS (Intel/Sparc), HPUX, Linux (RedHat/CentOS), UNIXWare, DOS.
Database: (administration, management, design, web interfacing/development, clustering, backup/recovery, log shipping, replication, database mirroring, database snapshots, Data Warehousing, DTS, SSIS, Oracle Sql Loader/import/export, ETL, optimization, stored procedures, triggers, DMV, UDF, OLAP/OLTP, Analysis services, SQL Reporting Services) - MS SQL Server 2005/2000/7.0/6.5, Oracle 8/8i/9i/10g on NT/Intel Solaris/HP/Linux (including PL/SQLand Perl procedures), MySQL, PostreSQL, MSAccess.
Services: Web: (administration, optimization, configuration) - Apache (CGI.pm, mod_perl, mod_PHP, Apache-DBI), IIS, MTS, IE/Netscape/Firefox. File Sharing: setup, configuration of NFS/Samba/FTP servers, UNIX-windows networking. Networking: setup, configuration of DNS(Bind 8)/Sendmail, Telnet, RSH, RCP, FTP, TCP/IP, Netbeui, NFS, Squid, IPX/SPX, CISCO, ipchains, routers, firewalls, gateways (Linux).
Others: Cluster Administrator, Veritas Netbackup, Tivoli Storage Management, TOAD, Quest Central, Quest Spotlight, I-watch, Remedy, Visual Studio.NET, VMWare, Microsoft Virtual Server 2005, Visual Interdev, SAN, Dreamweaver, Ultradev, Frontpage, Adobe Photoshop, Paintshop, RAID, Visual SourceSafe, Lotus Notes, Putty/Plink, Crystal Reports, Management Studio, Business Intelligence Development Studio, Upgrade Advisor


PROFESSIONAL EXPERIENCE:

Odyssey Reinsurance
Database Administrator
Dec '07 -- Present

Responsibilities:
• Production Infrastructure DBA Support - Responsible for administration of almost a hundred instances comprising of several hundreds of databases with sizes up to 300Gb+ and 500Gb+.
• Installation of Sql Server (2000 and 2005). Upgrade and migration of SQL 2000 MSDE to SQL 2000 full versions. Upgrade and migration of SQL 2000 to SQL 2005. Identifying inefficient server settings and database options of existing servers/databases, change as necessary.
• Ensuring that all databases are backed up on a regular basis by monitoring full, differential, transaction log backups for oltp, warehouse, and business object repositories. Fix backup failures, address and implement resolutions.
• Design and creation of database backup solutions taking into account disk space consumption, data transfer latencies, scheduling, I/O performance.
• Creation of database maintenance plans, rebuild/defrag indexes, integrity checks. Creation of TSQL scripts for full, differential, transaction log backups, optimizations, integrity checks on some instances that has special requirements beyond maintenance plans.
• Restoring databases as requested. Recover/restore as necessary, troubleshoot databases with data consistency/torn page problems.
• Monitoring disk space utilizations, sizing, and capacity planning. Adjusting database sizes and restricting maximum size appropriately.
• Running of performance monitor, Sql profiler, or querying server to identify performance problems on servers experiencing bottlenecks.
• Collaboration with engineering, development, production teams to implement certain projects.
• Creation of change management documents/tickets during production change.
• Documentation of Sql server standard operations, procedures.

Environment: SQL Server 2000/2005, Tivoli Storage Management, DTS/SSIS, TSQL, VMWare, Footprints, NetIQ


Safeway Philtech
Database Administrator
Sep '06 -- Oct '07

Responsibilities:
• MS SQL/Oracle DBA infrastructure support Provide support on remote production and development servers in US, clustered/non clustered environment DBMS Maintenance, backup and recovery Implement, configure, administer replication and log shipping Installation/upgrade, patch application, db migration.
• Security implementation and user management on SQL servers Capacity planning, manage data storage and data file placements Performance monitoring, tuning, implement performance improvements of database instance/environments Resolve problem tickets thru Remedy system Monitor database production utility jobs for errors, correct problems and upgrade as required.
• Implement SQL Server/Oracle related change requests Provide documentations for all implementations, setup and configuration Constant collaboration with offshore DBAs, operations and for project owners as needed. DBMS Maintenance Apply maintenance releases and upgrades to the DBMS Provide diagnosis to DBMS vendor to resolve problems.
• Apply emergency maintenance fixes to the DBMS Database Backup & Recovery Execute the database backup Procedures as required per the backup & recovery policy Ensure current logs (such as transaction logs, redo logs and accumulations) are available for database recovery of the production databases, in the event of system or hardware failure.
• Point-in-time Recovery of the production databases, in the event of application failure Veritas Netbackup
• Database Security Ensure all production databases are access restricted Provide production next level support to Security team Production Database Support Ensure production databases are available as defined in the Service Level Agreement Monitor database production utility jobs for errors, correct problems and upgrade as required.
• Manage data storage, including datafile placement, compression and migration Apply application release upgrades Apply major, minor application changes to production database Monitor, test and control the completeness, accuracy and validity of data.

Environment: SQL Server 7.x/2000/2005, Oracle 8i/9i/10g, Veritas Net Backup, clustered/non-clustered environments, Replication, Log shipping, Remedy System, Quest Spotlight, on call DBA Support.


Telus International
Database Administrator
Apr '06 - Sep '06

Equicom Systems Management
Responsibilities:
• MSSQL/Oracle DBA offshore support Provide support on remote production and development servers in Canada and US, clustered/non clustered environment DBMS Maintenance, backup and recovery Installation/upgrade, patch application, db migration Resolve problem tickets thru Remedy system Monitor database production utility jobs for errors, correct problems and upgrade as required.
• Implement SQL Server/Oracle related change requests Provide PLSQL scripts for data loading, used SqlLoader, Import/Export utility Provide in-house Perl scripts used in backup and recovery and RMAN integration Develop, revise Perl scripts to support database management, such as backup, monitoring, health reportingand RMAN.
• Health reporting and root cause analysis Provide documentations for all changes, setupand development contributions Provide on call supportand ensure all production database servers are available depending on SLA agreement Database Performance & Capacity Monitoring, Tuning Planning and Reporting Monitor critical database performance components and space utilization and their respective thresholds.
• Analysis and reporting of database performance and capacity: *Silver:1 per yearand upon requests based on a per unit price agreement Implement performance improvements to the database environment/instance, based on the analysis above Implement database performance improvements and capacity upgrades based on workload and growth forecasts from the client.
• Capacity planning at the database instance level Review and recommend changes to the application to improve database access/update performance Assist application developers with problem identification.

Environment: SQL Server 2000, SQL Server 2005, Oracle 8/8i, 9i, 10g on UNIX and Windows, Perl scripting, UNIX shell scripting, Veritas NetBackup.


Sykes Asia Inc
Database Administrator
Dec '02 - Apr '06

Responsibilities:
• Administration, monitoring, performance tuning, backup and recovery, log shipping, upgrade, security and management of 9 online production servers comprising of 100+ databases using MSSQL Server 7/2000/2005 on WinNT4/2000/2003 platforms. Database Design, Data modeling, Logical database design, Physical database design, Physical database design review.
• Create database definitions and DB objects as designed Provide the necessary DDL, programs and Shell scripts to perform data conversions required to move from one application release to another Development Database Support Backup and Recover (refresh) of one: either a QA, user training, development, or test database, by an automated “refresh” regularly run, e.g., once per month.
• Create (replicate/clone) and maintain additional QA, training, development or test databases Data loads, unloads and reloads and conversions Apply database changes as required to support application development, testing Used Query Analyzer to execute most of SQL commands including process management, monitoring.
• Optimization, maintenance, security management, backup/restoration/recovery, used Profiler for filtering and tracking SQL statements and server activities, index management, etc. Provides data extracts to clients for corporate reporting and analysis purposes. DTS, ETL, database scripting using TSQL for ETL process.
• Data warehousing (Analysis Services) - analysis, cubes, online reporting Creates Stored Procedures, Triggers, User Defined Functions (UDF) to support the development team project. Converted hardcoded programs into Stored Procedures to generate tabulated reports. Design, optimization of database driven applications (smart clients, web applications).
• Mentored team and provided consultancy to team of developers
• On call support -- remote administration of DB servers, anytime. Documentation - in compliance with SOX (DB security, process/procedure, business continuity, DARP standards).

Web Applications Development using .NET
• Developed an online Employee Profile application using ASP.NET/VB.NET -- employees log in to this site if there are update in their profile (address, contact numbers, sss no, philhealth no, etc)
• Developed an online application for employee Medical Benefit records using ASP.NET/C# - employees log in to this website to update their profile for the health provider, add dependents for the health insurance, etc.
• Developed an online monitoring of SQL Servers using ASP.NET/VB.NET -- this application pulls up information from tables generated by sql agent jobs that contains statistical data for database servers health, capacity, configuration presented on graphs and tables.

Environment: SQL Server 2000/2005, Veritas NetBackup, DTS, IIS, ASP.NET, VB, C#, SSRS


Fujitsu Computer Products Corporation
MIS Data Systems Engineer 2 (DBA, Web Developer)
May '99 -Sep '02

Responsibilities:
• Administration, maintenance, setup of database servers. MS SQL Server, Oracle 8/8i under WinNT and UNIX platform. Designed and planned table structures, write Stored Procedures, Triggers and scripts in MS SQL and Oracle. Performs administrative tasks including backup, recovery, load analysis of web and database servers.
• Configured Oracle8i running on Intel Solaris 7 with mod_ Perl, DBI/DBD to Integrate with Apache. Wrote Triggers, Stored Procedures in PLSQL to provide text file data used by manufacturing for reporting. Responsible for administration, maintenance, optimization and setup of servers from the ground up to a fully-featured running web and database servers.
• Installed, configured IIS, MTS for NT servers. Installation of UNIX web servers using Solaris 7, or Red Hat Linux as Operating System, Apache, mod Perl, DBI, DBD and many other necessary Perl modules. Responsible for intranet web development for the company including database interfacing for MS SQL Server, Oracle 8/8iand text file formats under WinNT/UNIX Operating System environments.
• Client-side and server-side programming using modern web techniques, ASP, CGI, Perl, VBScript, Javascript, used Visual Basic for DCOM/COM objects. Created intranet for the company exchange of internal information. Write several programs in Visual Basic used by the manufacturing system as requested by different departments inside the company to match and automate various tasks.
• Leads the intranet development team, project management, planning and program deployment and assigns particular tasks to team members. Designed, coded and implemented interfaces for several web projects, including graphics, HTML layouts, database front-end and scripting.

SOME OF MY PROJECTS INCLUDE:
• Document and Training Support System - This project is the web implementation of the company's document control system. The system is created for a paperless circulation, control of corporate confidential standard documents which automatically converts uploaded files into PDF format and make them available on the web for reference.
? Responsible for the hardware planning (includes capacity, system requirements), setup and development. Used ASP, VB6, VBScript, Javascript, COM/DCOM, Acrobat, MS SQL Server 7, IIS, MTS, Visual Interdev, Photoshop. Training Database Application - This project is a web interface for the company's database of employee records and trainings.
• Training Database Application - This project is a web interface for the company's database of employee records and trainings.
? Responsible for the setup of web server and database server. Design, graphics, layout, development using IIS, MTS, ASP, VB 6, VB Script, Java Script, DCOM/COM, MS SQL Server, used Stored Procedures, Triggersand Full Text Indexing Search. Used Photoshop, Dreamweaver, Visual Interdev.
• FCPP Visitors Application Web Site - This local intranet site provides the visitors easy submission of their application to visit the company. Includes hotel reservation, flight details, rentacar services, etc. responsible for the setup of web and database server, both on UNIX platform.
? Used Solaris 7 OS, Apache, installed mod_Perl, Apache-DBI, DBI, DBD and many Perl modules. Installed, configured UNIX Oracle 8i as backend database. Developed the web system using CGI, Perl, Javascript, used Net-SMTP for email processing, DBI, DBD-Oracle, LWP, Spreadsheet, and other required modules.
? Designed the database table structure and write Oracle Triggers, Stored Procedures, PLSQL scripts and UNIX shell scripts.
• Allegro Web Inquiry - This project serves as an inquiry web page for the manufacturing system who wants to get the real time information of a HDD from online production UNIX data servers.
? Responsible for setup of web server, development, design and planning. Used Solaris 7 OS, Apache, CGI, Perl, Javascript. Write Shell scripts that are executed to get the data from several UNIX Solaris online servers in text file format. Also used RSH, RCP, bourne Shell scripting, FTP. Dreamweaver, Photoshop.


Siemens Inc
Technical Support Engineer (OJT)
Oct '99 - Dec '99
Visual Basic programmer, also performs email/internet configuration, network installation, software installation, hardware/pc setup and troubleshooting/repair.


EDUCATION:
Bachelor of Science in Computer Engineering 94-Mar 99 Polytechnic University of the Philippines - Sta. Mesa, Manila, Philippines.

TRAINING:
Oracle 10g Administration Workshop 1 (Oracle University, Makati, Philippines)
70-315 Developing and Implementing Web Applications with C#.Net (Sykes Asia, Philippines)
Designing and Implementing OLAP Solutions with MS SQL Server 2000 (DB Wizards, Makati, Philippines)
Programming MS SQL Server 2000 (Sykes Asia, Philippines)
Oracle 8i Programming. (Aptech Computer Education, Makati, Philippines)
Oracle 8i Implementation. (Aptech Computer Education, Makati, Philippines)
SQLServer Administration (Iverson Makati, Philippines)
SQL Server Design and Implementation. (Iverson Makati, Philippines)
Java, Introduction and Advanced. (Aptech Computer Education, Ortigas, Philippines)



Certifications
MCP - Installing, Configuring and Administering Microsoft® SQL Server? 2000 Enterprise Edition.
MCP - Managing and Maintaining a Microsoft Windows Server 2003 Environment.
MCP - Developing and Implementing Web Applications with Microsoft® Visual C#? .NET and Microsoft® ASP.NET
Brainbench- Linux Administration, MySQL 3.23 Administration, RDBMS Concepts, HTML 3.2


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-CT-Stamford »
View all resumes in US-CT »

View other Database Administrator resumes, Database Administrator resumes