Post Job Free

Resume

Sign in

Administrator Data

Location:
Ambavaram, AP, 523112, India
Posted:
February 26, 2015

Contact this candidate

Resume:

PROFESSIONAL EXPERIENCE

Senior/Professional Database Administrator

IBM/COMPUTER SCIENCES CORPORATION

*/**** - *******

. LEAD DBA FOR CHRYSLER AND TOYOTA ACCOUNTS

. DATABASE SUPPORT FOR TOYOTA MOTORS IN TORRENCE, CA AND CHRYSLER MOTORS

IN TENNESSEE

. PLATFORMS ADMINISTRATED INCLUDE SQL SERVER 2000/2003/2005/2008 R2 AND

2012, MYSQL 5.X, NDB_CLUSTER,

. MAIN DUTIES INCLUDE INSTANCE CREATION DATABASE SECURITY, PERFORMANCE

TUNING, DISASTER RECOVERY SCHEMAS, QUALITY CHECKS OF EXISTING DATABASE

INSTALLATIONS, PUSHING CODE AND DATA BETWEEN ENVIRONMENTS.

. SUPPORTS APPLICATION AND OPERATIONAL TEAMS ON DATABASE DESIGN AND

HARDWARE CONFIGURATION.

. DEVELOPS AND SOLVES SPECIALIZED SOLUTION TO DATA MIGRATION, SYSTEM

CONFIGURATION, DATABASE AND OS CONFIGURATION

. AUTHORS DOCUMENTS ON NEW PROCEDURES AND POLICIES

. PRIMARY SUPPORT FOR DB2/ORACLE/SQL SERVER BASED TICKETING, BACKUP

REPORTS AND DATA MIGRATION.

. MENTORS NEW STAFF ON DATABASE AND APPLICATION TEAMS ON PROCEDURES AND

POLICIES AND HOW TO BEST IMPLEMENT SOLUTIONS

. PRIMARY INTERFACE WITH APPLICATION, MANAGEMENT AND QUALITY TEAMS

THROUGHOUT BOTH ORGANIZATIONS.

Revenue Solutions Inc. November 2012-March 2013

Alexandria, VA

Conversion Consultant

Responsible for determining data to be transferred from legacy to new

Oracle based Data Warehouse environment for NCDOR.

. Used Oracle 11i w/ SQL Loader and SQL*Plus for code development.

. ETL Process Coordinator

. Data Quality Auditor

. PL/SQL debugger and coder for stored procedures, triggers and

functions.

. Developed new processes for ETL from legacy to new systems

. Mentored new hires on process and coding.

DBA / Developer July 2012 - September 2012

Listingbook - Greensboro, NC

. SQL Server 2008 R2 DBA/ Developer

. Managed data sharing between different environments

. Managed software lifecycle for new deployments of MLS areas

. Writes queries in T-SQL to support the adding of new MLS listings.

. Uses GIS to install new search areas for upcoming MLS areas

. Responsible for promoting new MLS area data from Development to QA to

Production Environments.

. Troubleshooting stored procedures, triggers, and functions in real

estate listing databases

. Member of conversion team implementing new MLS's

. Systems Administrator for to MS Server 2008 R2 SSMS, SSRS and SSIS

Database Administrator March 2011 - June 2012

RGI Informatics - Cornwallville, NY

. Sr. MySQL DBA

. Configures MySQL databases for use by training, QA, and end-users.

. Installs configures and connects MySQL databases onto Mac, CentOS

and Windows environments.

. Performs Performance Tuning of SQL Queries and Severson MySQL 5.1.x

Advanced Server

. Managed data sharing between different environments

. Established hardware, software and database modelling, sharing and

handling and documented all procedures according to company

standards.

. Architected new database model implementations and built

applications according to client requirements

. Establishes Policies and Documentation for Surround SCM Software

Repository Mac OS X servers including RAID configuration and disk

swap-outs.

. Supported new feature implementations according to SLDC company

guidelines

. Supported QA, Development and Implementation Departments with

database analysis, modelling and building as well as administration

and security.

. Installs and Configures Mac OS X Server versions 10.6 and 10.7 on

pre-approved hardware

. Configures MacBookPro and Windows 7 and Vista laptops for VPN

connectivity.

. Configuration and Troubleshooting of Apache Server Installations

. Installation of Software critical to VA effort to electronically

store medically relevant data, including STATA, and various Darwin

dependancies and applications to allow connectivity to a variety of

databases, including SQL Server and Oracle.

. Configures virtualization for DR purposes using VirtualBox, VMWare

and Parallels.

. Holds Public Trust Clearance with Veterans Administration.

Database Administrator August 2010 - March 2011

Research Triangle Institute - Raleigh, NC

. Responsible for continual operation of all SQL Server 2000/2005/2008

R2, MySQL 5.x and Oracle 10g instances and databases in many

environments, including DoD/DHS security compliant data.

. Supported QA, Development and Implementation Departments with database

analysis, modelling and building as well as administration and security.

. System Administrator for Windows Server 2003 and SQL Server

200/2005/2008 R2

. Managed data sharing between different environments and coordinated

new database schema and specialized database platform services

. Leader of team to automate database creation for customers.

. Leader of evaluation team for various monitoring software and

schemas, such as Quest and Zenoss.

. Performance tuning of databases.

. Troubleshooting of SSIS and DTS legacy packages.

. Performing Ad-Hoc SQL queries for customers.

. Various database related application configuration and tuning.

Chief Technology Consultant July 2010 - January 2014

Pb2Au - New York, NY

. Main technology advisor for startup Intellectual IP consulting firm

. Responsible for all aspects of technology consultation for novel and

patentable hardware and software inventions.

. Chief Data Architect for CRM and web based applications

. Supported database and IT technological development projects company-

wide

. Designed, implemented and maintained back-end database instances

needed for novel and open-source application packages

. MySQL database design based on PHP form data collection.

. Web design and modification using CSS, Dreamweaver, Flash and PHP.

. PostgreSQL database design and implementation for project related to

onset of age related disease diagnosis.

. CentOS, Apache, MySQL 5.2 installation and administration for

corporate web presence.

Systems Administrator January 2010 - June 2010

College Foundation, Inc. - Raleigh, NC

. Primarily Responsibility for SQL Server 2000, 2005 and 2008 R2

instances in Production, QA, Testing and Staging Environments.

. Managed data sharing between different environments

. Established hardware, software and database modelling, sharing and

handling and documented all procedures according to company standards.

. Architected new database model implementations and built applications

according to client requirements

. Primary support for QA and contract programmers in a .NET based

environment.

. Performing Ad-Hoc SQL queries for customers.

. Database Instance Creation in all environments

. Database Security for users, groups and objects on SQL 200/2005/2008

R2

. Database Backup using IBM Tivoli Storage Manager command line

inputs.

. Database Tuning using Microsoft tools to optimize both database

engine and query performance.

. IIS Administration of external and internal websites, including

building, deployment of new code, troubleshooting and maintenance.

. Database Architecture duties, including diagramming in Visio,

Reverse Engineering, comparisons, using RedGate software tools,

between various environments and normalizing data.

. Importing large batches of data to various environments from text,

Excel and Access and other database sources.

IT Support Analyst August 2009 -January, 2012

Bowlin Enterprises

. Hardware Troubleshooting and upgrading

. Application Troubleshooting and configuration

. Web page design and troubleshooting.

. Staff support and training.

. Remote support of all IT related issues.

. Advisement of hardware and software purchasing and configuration.

. Network Administration and Troubleshooting

. Report template generation.

. Database retrieval using SQL queries

Database Analyst December 2008 - May 2009

Ateb, Inc / DISYS, Inc - Raleigh, NC

. Troubleshooting PostgreSQL database issues related to performance,

connectivity and content.

. Providing advice to System Administration team for optimal storage of

company data and PostgreSQL administration and configuration.

. Experience developing strategic solutions to complex business

problems involving translation and mining of data from production

to statistics departments.

. Design of database tables, file structure, DDL and DML packages.

. Architecting of newly deployed database and data warehouse components

for statistical analysis.

. Assisting Statistical and Clinical programmers with analysis of

requested data.

. Writing Ad-Hoc SQL queries to retrieve requested data from IVR,

Outbound Calling and reports databases.

. Writing R code to query databases, retrieve and package data for

statistical analysis

. Troubleshooting SPSS, R, and SQL queries.

. Authoring iReports for internal business customers, and submitting to

web administration application for scheduling.

. Troubleshooting iReports for functionality Reverse Engineering of

existing database structures. Establishing offline databases for

reporting purposes.

Oracle DBA September 2008 - December 2008

Autonomic Resources - Cary, NC

. Oracle 9i and 10g DBA responsible for account creation, security,

tuning, database cloning, and environment refreshes.

. Led business analysis and business development inititibes

. Administrator of Jasper Server and iReports generation.

. Participated on on-call rotation.

. Database Monitoring of all Oracle instances.

. Oracle Application set-up Oracle Applications Administrator on Solaris

9, 10 and AIX.

. System Administrator on Solaris 9, 10 and AIX.

. Optimized database implementation on SAN using various RAID schema

Database Administrator April 2008 - June 2009

LimeLeap Solutions - Washington, DC

. Database Administrator: SQL Server 2000/2005

. System Administrator: Windows 2000/2003

. Remote Position

. System, Database and application architect for hosted company OLTP and

reporting instances.

. Instance Installation and Configuration for Accepting Corporate Data.

. Database Engine, Instance, Database and Table Creation

. Designing of database tables, indexes, stored procedures and triggers.

. Database Backup, Restore, Disaster Recovery and Testing System and

Performance Monitoring

. Database and Windows Server 2000 and 2003 Parameter Tuning

. SQL Query Tuning

. Managed data sharing between different environments

. Established hardware, software and database modelling, sharing and

handling and documented all procedures according to company standards.

. DTS Package Troubleshooting

. Hardware and Software Evaluation and Recommendations to Development

Director

. Root Cause Analysis for Interruptions in Production Environment

. Database Server and File Auditing

. Security Auditing, Recommendation and implementation

. System planning for optimization of performance

Senior Database Administrator August 2007 - September 2008

Peopleclick Inc - Raleigh, NC

. Database Administrator: MySQL 4.1.x - 5.0.x, SQL Server 2000/2005,

Oracle 11g

. System Administrator: Red Hat Linux, Windows 2000/XP/2003, Vista,

Apache 2.x, PHP 5, Nagios

. Duties

. Instance Installation and Configuration for Accepting Corporate Data.

. Database Engine, Instance, Database and Table Creation, Upgrading and

Maintenance.

. Database Backup, Restore, Disaster Recovery and Testing.

. System and Performance Monitoring.

. Managed data sharing between different environments

. Established hardware, software and database modelling, sharing and

handling and documented all procedures according to company standards.

. Database architect, implementer and policy establishment and

documentation for new software inititatives

. Performance tuning for SQL Server and MySQL instances and databases

. Database Replication, Mirroring and Log Shipping.

. Designing customized table structure in MySQL for Sugar CRM deployment

and then porting structures and data to SQL Server 2005 instances and

databases

. Lead DBA Support for Data Warehousing Operations.

. OLAP Cube Troubleshooting, Construction and Configuration.

. Participating in on-call rotation in 24x7 Network Operations Data

Center.

. Root Cause Analysis for Interruptions in Production Environments.

. Hardware configuration Consultant. Windows Cluster Administration.

Database Scripting.

. ETL Development and Deployment.

. DTS and SSIS Package Troubleshooting

. Security Auditing, Recommendation and implementation

. Optimized database implementation on SAN using various RAID schema

Database Systems Administrator January 2005 - August 2007

CarQuest Inc. - Raleigh, NC

. Database Administrator: MySQL 4.1.x - 5.0.x, SQL Server 2000/2005, DB2

UDB v8.x, PostreSQL 7.x, Oracle 9i, 10g

. System Administrator: Red Hat Linux, AIX, Sun Solaris 9/10, Windows

2000/XP/2003, Apache 1.x, 2.x

. Instance Installation and Configuration of Database Engine

. Database and Table Creation, Upgrading and Maintenance

. Database Backup, Restore administrator

. Database platform performance tuning.

. Network, User, and Server Security Administrator

. Database Replication, Mirroring and Log Shipping

. Participating in on-call rotation in 24x7 Network Operations Data

Center

. Managed data sharing between different environments

. Established hardware, software and database modelling, sharing and

handling and documented all procedures according to company standards

. Replication setup, monitoring and administration

. Database architect, implementer and policy establishment and

documentation for new software initiatives

. Root Cause Analysis for Interruptions in Production Environments

. Windows, Solaris, and AIX OS Cluster Administration

. Database Server and File Auditing

. Custom database and instance design of MySQL and DB2

. BASH, Perl, and PHP Scripting Web Server Administration

. Optimized database implementation on SAN using various RAID schema

Systems Analyst October 2003 - January 2005

Becton Dickinson Technologies

. Database Administrator: MySQL 4.1.x - 5.0.x, PostreSQL 7.x, Sybase

. System Administrator: Mac OS X, Mac OS X Server, Mac SAN, Windows 2000,

2003, Apache 2

. Network Administrator: Mixed Windows, Mac environment

. Duties

. Database Engine, Instance, Database and Table, DML and DDL custom

Creation from collected design criterion Database Backup, Restore,

Disaster Recovery and Testing.

. System and Performance Monitoring.

. Managed data sharing between different environments

. Established hardware, software and database modelling, sharing and

handling and documented all procedures according to company standards

. Replication setup, monitoring and administration

. Database architect, implementer and policy establishment and

documentation for new software initiatives

. Supported new feature implementations according to SLDC company

guidelines

. Supported QA, Development and Implementation Departments with database

analysis, modelling and building as well as administration and security.

. Creating PHP Interfaces to Access Antibody and Instrument Generated

Data.

. Analyzing Present and Future Needs and Preparing Reports and

Presentations for Capitol Purchases.

. Network, User, and Server Security.

. Interfacing with Scientific Investigators to Determine Hardware and

Software Needs.

. Scientific Data Archiving and Storage.

. Consulted with Bio-informatics Department on Software Development

Projects.

. Root Cause Analysis for Interruptions in Productions Environment.

. Database and Table Development .Data Normalization and Modeling.

. ETL Development and Deployment.

. Perl, BASH, and PHP Scripting

Database Systems Administrator October 2000 - October 2003

StemCo Biomedical, Inc. - Durham, NC

. Database Administrator: SQL Server SBS 2000, Access

. System Administrator: Mac OS 9/X, Windows 2000/XP/2003

. Network Administrator: Mixed Windows, Mac environment

. Duties

. Consulted with External Vendors on Software Development Projects

. Configured routers to allow FTP, VPN, and RADIUS access to servers

. Access DBA for patient and sample data.

. Authored and implemented security policy for Network, UNIX, Mac, and

Windows Servers and Desktops

. Responsible for Backup of Scientific and business data using VERITAS

and Retrospect Suites

. Business analysts for specialized software initiatives

. Managed data sharing between different environments

. Established hardware, software and database modelling, sharing and

handling and documented all procedures according to company standards

. Replication setup, monitoring and administration

. Database architect, implementer and policy establishment and

documentation for new software initiatives

. Supported new feature implementations according to SLDC company

guidelines

. Supported QA, Development and Implementation Departments with database

analysis, modelling and building as well as administration and security.

. Participated in planning, development, and design and testing of bio-

informatics software.

. Planned, designed Ethernet network and handled contracting for

implementation.

. Prepared and presented business analysis studies for purchasing major

equipment upgrades.

. Primary IT support for Windows 2000, XP, Mac OS 9, and UNIX

IT LAN Administrator / Access August 1999 - October 2000

Duke University Medical Center - Durham, NC

. Windows 98, NT, 2000, Mac OS 9 system administrator.

. Responsible for storage and backup of clinical research data on

networked computers.

. Designed and implemented Access 2000 database for clinical trials

patient data, including table structure field optimization and design

from criterion,

. Operated image facility using Spot and Adobe Photoshop for acquisition

and analysis of fluorescent image data.

. Acquired, analyzed and warehoused flow cytometry data using CellQuest

and VERITAS DVD systems.

. Administrated data backup for scientific and clinical data.

. Group IT support for Windows 2000, 2003, Office, UNIX and Mac OS 9.

MySQL DBA December 1997 - August 1999

University of North Carolina Chapel Hill

. DBA for the Liver Stem Cell Biology group.

. Purchasing, installing, upgrading troubleshooting and configuring PC

and Macintosh machines.

. LAN administrator on Windows NT and Mac OS 9 network.

. Acquired, warehoused, and statistically analyzed flow cytometry data

using Summit, Cyclops CellQuest front-end software with Sybase and MS SQL

7 back-end database servers.

. Acquired, warehoused and analyzed image data using Leica TCS and Adobe

Photoshop software.

. Designed table, index, stored procedure and trigger structures for

customized data storage.

IT Administrator January 1997 - December 1997

Astra Arcus AB - Sodertalje, Sweden

. Manager of the flow cytometry facility for Astra Arcus AB.

. Involved in purchasing, configuration and installation of PC and

Macintosh machines on corporate network and instructing others on usage.

. Information Systems/Information Technology Administrator and member of

the corporate IS/IT committee.

. Webmaster for the Neuroimmunology section.

. Main contact for editing internal and external reports for English

grammar and content.

Network Engineer December 1992 - January 1997

Duke University Medical Center - Durham, NC

. Responsible for maintaining, acquisition, storage and archiving of flow

cytometry data generated by facility instruments.

. Network Administrator for a mixed PC, Mac, and UNIX network

environment.

. Responsible for computer installation, configuration, troubleshooting

and repair.

. Evaluated new technologies for use in facility operations.

. NAS storage administration for UNIX based system.

. Developed billing and maintenance tracking system using Excel

EDUCATION

NORTH CAROLINA CENTRAL UNIVERSITY, Durham, N.C.

B.Sc. in Mathematics (Magna Cum Laude)

Concentration in Computer Science.

TRAINING

. Data Analysis using Programming Statistical (R statistical software),

online, Coursea.org

. MATHEMATICAL METHODS FOR DATA ANALYSIS (MATLAB SOFTWARE), ONLINE

COURSEA.ORG

FOR SQL SERVER 2012, ONLINE COURSE THROUGH CSC

. JASPERSOFT BI SUITE, JASPERSOFT, SAN FRANCISCO, CA

. MICROSOFT CLUSTER TRAINING, PEOPLECLICK, RALEIGH, NC

. ORACLE DA I AND II, WAKE TECH, CARY, NC

. ORACLE PL/SQL, WAKE TECH, CARY, NC

. DB2 ADMINISTRATION FOR EXPERTS, JACK MORTON, DURHAM, NC

. WRITING QUERIES USING TSQL, NEW HORIZONS, MORRISVILLE, NC

. MAINTAINING A SQL SERVER 2005 DATABASE, NEW HORIZONS, MORRISVILLE, NC

. DB2 ADMINISTRATION FOR UNIX, JACK MORTON, DURHAM, NC

. SQL SERVER 2000 ADMINISTRATION, GLOBAL KNOWLEDGE, CARY, N.C.

. MYSQL DATABASE PERFORMANCE AND TUNING, MYSQL AB, RALEIGH, NC

. CISSP PREP COURSE, NEW HORIZONS, MORRISVILLE, N.C.

. PERL LEVEL I&II, NORTH CAROLINA STATE UNIVERSITY

. NETWORK SECURITY II, GLOBAL KNOWLEDGE, CARY, N.C.

. NETWORK SECURITY I, GLOBAL KNOWLEDGE, CARY, N.C.

. XML LEVEL1, NORTH CAROLINA STATE UNIVERSITY

. PHP/MYSQL, NORTH CAROLINA STATE UNIVERSITY

. R/S PLUS, BD TECHNOLOGIES, RTP, N.C.

. CLARA ROBOTICS MANAGEMENT SOFTWARE TRAINING, CALIPER, BRAINTREE, MA

. MS SQL 2000 ADMINISTRATION, DBBASICS, RALEIGH, N.C.

. MS PROJECT, PRODUCTIVITY POINT, MORRISVILLE, N.C.

. ACCESS 2000 / BEGINNING, INTERMEDIATE, ADVANCED, NEW HORIZONS, DURHAM,

N.C.

. ORACLE SQL*PLUS AND PL/SQL, NORTH CAROLINA STATE UNIVERSITY, RALEIGH,

N.C.

Current Webmaster for the following sites:

PB2AU.COM

SERENITYEXPRESSIONS.COM

COMFORTPARADIGM.COM

GEORGEPOWELL.NET

DANNY.MYSTITECH.COM

MEMBER OF THE BOARD OF DIRECTORS OF THE NETWORK OF TRIANGLE ASTROLOGERS



Contact this candidate