PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Database Administrator

Responsibilities:

• Production support for databases for MS SQL Server (95%) and Sybase database systems.
• Installations, configuration, troubleshooting, performance tuning and documenting on clusters and standalones for MS SQL Server 2005, 2008 R2, 2012
• Plan database migrations or upgrades using MS PROJECT
• Collect metrics (IO, CPU, Memory) for MS SQL environment in planning for virtualization using PowerShell
• TPC benchmarking for tests on Physical and Virtual environments on MS SQL 2008 R2 / 2012.
• Lead yearly ACL Audit security reporting and support using PowerShell
• Lead Sybase database system administration, migration to 64 bit in ASE 12.5.4 setup auditing and support compliancy.
• Lead and participate in Disaster recovery planning and execution for onsite and offsite
• Snapshot Replication setup for MS SQL Server database systems
• Assist developers in setting partitioning schemes and table compression implementation for database models.
• Optimization using query analyzer\sql profiler\performance monitor to analyze server performance.
• Migration to MS SQL 2008 R2, MS SQL 2012, upgrade database and batch processes to SSIS.
• Setup and support MS SQL Server auditing for production servers
• Move\Refresh databases between MS SQL Servers,
• Administer user security setup\modifications within databases
• Setup administer and support application teams in SSIS and SSRS
• Setup\Document batch processes in sql agent
• Read and understand data models to query\extract data using sql or POWERSHELL\SSIS\SSRS

Confidential, New Jersey

Consultant Database Administrator

Responsibilities:

• Key project database support role.
• Plan database activities for system conversion within team and document tasks using excel.
• Script security changes and ETL requirement using DTS\SSIS. Build file loads using SSIS.
• Move\Refresh databases between servers
• Administer user security setup\modifications within databases
• Setup\Document batch processes in sql agent
• Install\configure\document sql server 2000\2005 on stand alones
• Migrate SSRS across servers.
• Read and understand data models to query\extract data using sql or DTS\SSIS.
• Optimization using query analyzer\sql profiler\performance monitor to record server performance.

Confidential, Melbourne Australia

Database Administrator

Responsibilities:

• Key member of project team playing role of database administrator in SQL Server 2000.
• SQL Server 2000 management in development, test and production environments.
• Application Support for Intellectual Property Software INPROTECH Release 3.3
• Organize data updates, database connectivity, database backups, space monitoring and recovery using transaction logging.
• Create test/UAT environments for use and refresh periodically for analysts.
• User login creations and testing connectivity.
• Software deployment over development, test and production systems.
• Data reporting using MS Excel, (reports and pivot tables)
• Use SQL profiler to find bottling SQL.
• Use performance monitor to analyze server performance.
• Build database conversion package using SQL server scripts and implemented using SQL Server 2000 data transformation services.
• Arrange download of data from Universe to SQL Server 2000 to form source database
• Write SQL scripts using a field - mapping document to convert from a source database to destination database.
• Assist in testing of conversion database.
• Analysis source database with business analysts to build reports for data scrubbing exercises
• Interfaces
• Arrange extraction of changes to client data and new clients from live database on periodic basis for load to a IBM Universe database system. Data extracted in fixed text file format.

Confidential

Database Administrator

Responsibilities:

• Manage productions systems for all database applications within organization.
• Production support for all databases.
• SQL Server 2000 \ SYBASE ASE 2.5/11.9.2 installations\administration\support. iPlanet 6.0 Web Server \ LDAP installation, application deployment and administration
• Setup, administration of PVCS Version Manager
• Applications deployment over dev, test and production systems
• Change control Management using PVCS
• Organize Batch tasks, Data updates, database usage, database Backups, Space allocation
• Development and Test environment refreshes
• User login creations and testing connectivity.
• Provide support to developers and to business analyst with SQL queries, stored procedures and database concepts.

Lead Analyst Programmer

• Play lead developer role for data conversion project from Mainframe to Sybase/MS Sql Server
• Lead Data conversion from Mainframe to Sybase\Sql server. Write application in VB 5 to read data, apply business logic and apply to target SYBASE 11.9.2 database.
• Analyze, document and develop 2 tier business application systems using Microsoft Access 8.0, Visual Basic 6.0 as client and SQL Server 2000 and Sybase 11.9.2 as backend database.
• Document process and operations \ user guides and installation guides for applications.

Confidential

Analyst Programmer / Web developer

• Analyze, document and develop 2 tier business application systems using Microsoft Access 8.0, Microsoft Access 2000, Fox Pro 2.6, Fox Pro 6.0 and Visual Basic 6.0. Web development in Cold Fusion and Netscape Server