OBJECTIVE

• A highly accomplished Database Technology Professional wif over 20 years industry experience leveraging Database technologies and cloud platforms in teh design, development and implementation of large scale technology solutions.

TECHNICAL SKILLS

Oracle DBA: Oracle v10g, v11g, 12c; DBA, Sun Solaris, IBM AIX, HP HPUX, Linux and Windows installation and scripting.

SQL Server DBA: v6, v7, v2000, v2005, v2008, v2008r2, v2012; v2014; v2016; Windows designs, implementations and performance tuning; MicrosoftSQL Server Migration Assistant(SSMA); Microsoft Power BI

SQL Server DBA: v2008r2, v2012; Cluster implementations, HA, Log shipping, Always - on availability, Mirroring

MySQL DBA: v4, v5, v6, v7 windows, Linux designs, implementations and performance tuning, clustering, replication and data migration

Big Data Technology: Hadoop Distributed File System; Replication; Amazon Web Services; Map Reduce; YARN; MongoDB v2.4 -2.6; Amazon Web Services; Relational, hierarchical and graph databases, distributed data file systems, data federation and query optimization; Azure Cloud Services

Project Management: Project Managed via software manager, Team Lead, Technical Lead, Resource Management and Project Development

Peoplesoft: v5, v6.x, v7.x, v8.x, v9.x, HRMS, CRM, Implementations, deployments and performance tuning. Ptools v8.14-8.5x, Upgrade Assistant and new Upgrade Manager (9.2x)

Clinical Applications: MOM Reporting and Monitoring System; Eclipsys Clinical Application, MS SQL Server DB

Staff and Budget Management: Management of Technical Resources up to 50 on-shore & off-shore in all. Departmental Budget and Project Budget Management for hardware and staffing requirements. Resource Management and Cost Analysis.

Data Warehouse: Star Schema, Snowflake, Business Objects, Extract Transform and Load, data migration and performance tuning, Azure SQL DW

Big Data Strategies: Performance Management (non-transactional, social data), Data Exploration, Social Analytics (non-transactional, social data), Decision Science; Designing and developing scalable software architectures; Manipulate massive-scale datasets, Architectures for big data capture, representation, information extraction and fusion.

PROFESSIONAL EXPERIENCE

Confidential, Wayne PA

DBA Lead / Postgresql DBA /MS Azure DR Architect / MS SQL Server Database Architect & Administrator

Responsibilities:

• Worked wif systems administrators to implement cloud architectures that utilize industry best practices
• Implement cloud technology policies, and procedures for disaster recovery and archiving to ensure TEMPeffective protection and integrity of storage appliances and stored data assets
• Development of teh DR workload migration plan in conjunction wif application owners and other technical resources
• Establish appropriate end-user access control levels for stored data
• Review and deploy cloud system releases and vendor-supplied patches according to best practices
• Managed MS Azure accounts utilized for disaster recovery/storage/Big Data Platform
• Designed and Developed data migration strategy between on premise and Azure environments
• Administration of PostgreSQL multi node clustered and replicatedenvironments
• Monitoring of system performance utilizingPgAdmin, Splunk, Debeaverand command line tools
• Loaded multiple NOSQL databases including MongoDB, PostgreSQL, Couchbase, HBase and Cassandra.
• Defined data elements that were required for initial Big Data Platform
• Follow change control, incident response, and testing processes for modifications to cloud technologies and software
• Creation of power shell scripts to support automation and simplification of administrative task
• Maintained cloud systems support and architecture documentation
• Utilize Jira for time and project tracking
• Team designed and trained to follow Kanban or Scrum based on project or user story.
• Establish and document teh PostgreSQL/EnterpriseDB technology stack including standard operating procedures including startup/shutdown, backup/recovery, disaster recovery, fail over
• Provision production database enterprise manager server, replication server and replicated standby for disaster recovery
• Implement automated methods and industry best practices for consistent installation and configuration of PostgreSQL for production and non-production environments
• Manage backup and recovery functions for a PostgreSQL reporting data warehouse environment
• Setup alerting mechanism for both PostgreSQL database and supporting environment to ensure system health and maximum availability
• Developed strategy and implementation plan for transitioning MS SQL Server on premise to Azure cloud
• Created monitoring solution for production databases wif PowerShell, Solar Winds & SQL Server Mgmt Studio
• Database Consolidation from MySQL, DB2 & SQL Server into PostgreSQL Database (Data Warehouse Reporting)
• GG replication for changes from SQL Server, DB2 and MySQL to PostgreSQL
• Created & Documented high level SQL Server consolidation plan to upgrade older SQL Servers onto newer platforms
• Developed support plan for MS SQL Server databases including performance tuning & high availability requirements
• Documented plan to migrate SQL Server 2000 database into SQL Server 2012 instances wif very little complication
• POC: SQL Server 2012 to 2016 upgrades
• POC: SQL Server 2016 application testing
• SQL Server 2012 to 2016 upgrade on DEV Database
• SQL Server 2016 upgrade on TST Databases.
• SQL Server data migration from 2005 & 2008 to 2016
• Implement user access and security procedures in accordance wif SOX requirements

Confidential, West Long Branch NJ

Technical Team Lead

Responsibilities:

• Organized and facilitated Agile and Scrum meetings
• Scrum meetings included Sprint Planning, Daily Scrums or Standups, Sprint Check-In, Sprint Review & Retrospective.
• Drafted Enterprise Big Data Platform policy which was incorporated in executive Project Management guidance
• Defined scope for Big Data Platform and identified / Selected initial Use Cases that would drive Big Data Project
• Provided daily communications, scrum notes, sprint reviews reports, and project retrospectives
• Provided regular snapshots of project velocity and budget burn rate.
• Big Data Strategy - Developed Initial Approach and Selected Initial Technology Stack
• Big Data Strategy - performance management, data exploration, social analytics, data science
• Design and model database wifin teh NoSQL area to accommodate data solutions wif Hadoop and In-Memory DB
• Architect & Administrator Hadoop, MongoDB, MySQL,Hadoop Cluster
• Architect & Administrator Hadoop Cluster; Hadoop HDFS; Hadoop Hive; Hadoop Map Reduce; Hadoop Pig
• Design/Plan/Architect data ingestion strategy from 2000+ data sources into (HDP) Hadoop Data Lake
• Design/Plan/Architect ETL strategies for real time data pipeline ingestion to (HDP/HDF) Hadoop Data Lake
• Architect & Administrator Hadoop Horton works, Hadoop Yarn, Talend Analytics
• Oracle Golden Gate / Oracle Data Integrator / Hive / NoSQL Data integration design & configuration
• Architect & Administrator (AWS) GenGireXD, PostgresSQL, Greenplum, Hawq & Kafka environments; GoLANG Program
• Architect & Administrator (Azure) Hadoop Horton works, Hadoop Yarn, Hadoop Spark w/Mongo Cassandra & CouchDB
• Architect & Administrator (Azure) Hortonworks, Hadoop Yarn, Storm, Nifi w/Mongo, Cassandra & CouchDB
• Identify and improve data elements wifin existing data lakes and new data lakes still in design phase.
• Loaded multiple NOSQL databases including MongoDB, PostgreSQL, Couchbase, HBase and Cassandra
• Oracle12C Enterprise Metadata Management installation and deployment
• Oracle Enterprise Metadata Management - Impact Analysis, Annotation and Tagging functions, Reporting Source Lineage
• R & Python wif comprehensive proficiency; Scala - Architecture & Collection Library, REPL, Scaladoc, Refection, Macros
• Talend Data Integration- Reading an input file, Transforming data, Combining columns, Joining data sources
• Talend Data Integration- Creating metadata, Joining data sources, Capturing rejects, Filtering data
• Talend Data Integration- Filtering output data, Using multiple filters, Using context variables, Error handling
• Talend Data Integration- Setting up sales data files, Creating customer metadata, Creating product metadata
• Talend Data Integration- Creating database metadata, Joining data, Creating master Jobs
• Talend Data Integration- Master Data Management model design, deployment and configuration
• Replication of Data from JDE database into MS SQL and MySQL databases Platforms for reporting.
• MySQL Database administration and support and performance tuning.
• I setup MySQL monitoring scripts and index rebuild scripys for teh purpose of negating possible performance degrading activities.
• Provision MySQL instances, both in clustered and non-clustered configurations
• Administer database instances in AWS
• Ensure performance, security, and availability of databases
• Perl Scripting modifications and new script development.
• Backup and Recovery setup via scripts and 3rd party tools for teh MySQL, Oracle and SQL Server Databases.
• Performance tuning exercises wifin MS SQL Server 2012/2014 database and application parameters
• MS SQL Server Performance tuning exercises wifin MS SQL Server 2014 database and application parameters
• MS SQL Server Always Encrypted utilization; Dynamic Data Masking utilization; JSON Support;
• MS SQL Server Multiple TempDB Database Files; PolyBase; Query Store; Row Level Security;
• MS SQL Server R Comes to SQL Server; Stretch Database utilization; Temporal Table utilization
• Utilize Oracle Golden Gate and Golden Gate Veridata for both one directional and bi directional data replication
• GG replication for changes from Oracle, SQL Server, DB2 and MySQL to PostgreSQL
• 150+ MS SQL Server Database (Servers) housing over 900 SQL Server Databases - Consolidation/Data Migration
• 300+ Oracle Servers housing over 2200 oracle databases - Consolidation/Data Migration
• 150+ Sybase ASE Database - Consolidation/Data Migration
• 100+ MySQL Database - Consolidation/Data Migration
• 120 DB2 Database Servers housing over 300 DB2 databases - Consolidation/Data Migration
• DBA 12c (450+ PRD DB’s); SQL Server DBA 2012/2014/2016 (425+ PRD DB’s); DB2 DBA 9/10 (75 PRD DB’s)
• SQL DBA – Oracle 11i, 12c, 12c R2, OEM 13c; SQL Server 2012, 2014, 2016; DB2 11.1, 10.5, 10.1, 9.8, 9.7;
• SQL DBA – Backups, Performance Tuning, Parameter/Configuration Optimization, Partitioning, Query Optimization,
• SQL DBA – High Availability (RAC, Always On, Data Guard, HADR) Replication (Golden Gate, Native Replication)
• SQL DBA - Log Shipping, Database Restore, Database Refreshes, Monitoring
• SQL DBA – Meta Data Management, Log Management, IN-Memory Optimization, Database Cluster Tuning
• SQL DBA – SQL Profiler, Indexing Optimization, Parallel Query Optimization, Storage Optimization (Data Files, Logs)
• DB2/UDB DBA –11.1, 10.5, 10.1, 9.8, 9.7;
• DB2/UDB DBA – Backups, Performance Tuning, Parameter/Configuration Optimization, Partitioning, Query Optimization,
• DB2/UDB DBA – High Availability (HADR) Replication (Golden Gate, Native Replication)
• DB2/UDB DBA - Log Shipping, Database Restore, Database Refreshes, Monitoring
• DB2/UDB DBA – Meta Data Management, Log Management, IN-Memory Optimization, Database Cluster Tuning
• DB2/UDB DBA – Indexing Optimization, Parallel Query Optimization, Storage Optimization (Data Files, Logs)
• 150+ MS SQL Server Database (Servers) housing over 900 SQL Server Databases – Consolidation/Data Migration
• 300+ Oracle Servers housing over 2200 oracle databases – Consolidation/Data Migration
• 100+ MySQL Database – Consolidation/Data Migration
• 120 DB2 Database Servers housing over 300 DB2 databases – Consolidation/Data Migration
• Lead technical team responsible for performing teh Oracle JD Edwards Enterprise One, Financials and Supply Chain Management.
• Production Support / PY / QA Support / Development Support
• Performance tuning exercises wifin SQL Server 2012 parameters
• Performance tuning exercises utilizing SQL Server Indexing strategies (Utilizing SQL Profiler primarily)
• Performance tuning on queries that were poorly performing to identify ways to improve response time and through put (Utilizing SQL Profiler –MS SQL Server)
• Database Performance Tuning (MS SQL Server)
• Performed typical database and server maintenance and backup procedures
• Database Backup and Recovery and Disaster Recovery Design and Implementation
• Large data loads and updates from production into development environment
• Database Consolidation from Oracle, MySQL, DB2 & SQL Server into PostgreSQL Database (Data Warehouse Reporting)
• Review of teh database architecture as a whole to determine areas of improvement
• Performed database refreshes from production to py/dev/qa environments
• Performance Tune JD Edwards environments
• Performance tuning exercises wifin MS SQL Server database and application parameters
• Performance tuning exercises including index strategies database (MS SQL Server)
• Make recommendations to include table level partitioning where it would improve performance
• Best Practices model for disk level database data file improvements for performance gain (MS SQL Server)
• Always-on availability group for read-only secondary replica
• Recommended backup and recovery strategies for data protection and disaster recovery per teh SLA’s
• Deployment of windows Service Packs through windows update process and MS downloads.
• Support high volumes of production and development service requests
• Routine daily maintenance (watches space, backup, export, etc.)
• Management of Database Basics (Creating databases, managing transaction logs, sizing database and managing disk space usage and compacting database.
• Manipulating database objects (tables, indexes, table data, creating table triggers, stored procedures)
• Data Transformation Services (Create packages, replication, transformations)
• Install SQL 2016 evaluation in test environment
• POC: SQL Server 2012 to 2016 upgrades
• POC: SQL Server 2016 application testing
• Configure off-site backups in Microsoft Azure cloud storage
• DR Database Deployment wif Log shipping utilizing Azure VM wif SQL Server 2014

Confidential, Philadelphia PA.

Technical Team Lead / MS SQL Server Database Administrator/ Big Data Administrator / Hadoop Administrator / Hadoop Technical Lead

Responsibilities:

• Lead technical team responsible for performing teh performance tuning of teh ERRECA Clinical Application and teh databases associated wif teh applications for which teh databases were essential for.
• Performed ERRECA Clinical Application performance tuning (Query tuning, table resizing, data file group reorganizations)
• Production Support / Test Support / QA Support / Development Support
• Performance tuning exercises utilizing SQL Server Indexing strategies (Utilizing SQL Profiler primarily)
• Performance tuning on queries that were poorly performing to identify ways to improve response time and through put (Utilizing SQL Profiler primarily)
• Reviewed Windows 2008, VMware and EMC SAN for areas of improvements. Made recommendations in these areas that would benefit teh over system performance.
• Review of teh database architecture as a whole to determine areas of improvement when it came to performance tuning efforts
• Provided daily communications, scrum notes, sprint reviews reports, and project retrospectives
• Provided regular snapshots of project velocity and budget burn rate.
• Organized and facilitated Agile and Scrum meetings
• Scrum meetings included Sprint Planning, Daily Scrums or Standups, Sprint Check-In, Sprint Review & Retrospective.
• Drafted Enterprise Big Data Platform policy which was incorporated in executive Project Management guidance
• Defined scope for Big Data Platform and identified / Selected initial Use Cases that would drive Big Data Project
• Big Data Strategy – Developed Initial Approach and Selected Initial Technology Stack
• Technical Architect of analytics platform collecting usage from billions of records.
• After teh burn-in period team was able to execute 80% - 90 % of user stories over multiple sprints.
• Rapid bootstrapping of distributed team and excellent cadence build-up wif-in 2 iterations.
• High-performing and motivated team created wif record close to 95 % participation in agile meetings.
• Team designed and trained to follow Kanban or Scrum based on project or user story.
• Executive briefing and reporting on scrum metrics, burn-up and process improvements periodically.
• R & Python wif comprehensive proficiency; Scala – Architecture & Collection Library, REPL, Scaladoc, Refection, Macros
• Deployment of Hadoop and Spark ecosystems.
• Regression, trees, neural networks, survival analysis, cluster analysis, forecasting, anomaly detection, association rules.
• Detailed understanding of machine learning pipelines and ability to discuss concepts such as feature discovery/engineering,
• Machine Learning - model evaluation/validation, online vs. offline learning, and model deployment.
• Implemented backend platform for large scale ingest using HBase client modules performing fine grained analytical reports
• Designed teh real time analytics and ingestion platform using Storm and kafka.
• Loaded multiple NOSQL databases including MongoDB, PostgreSQL, Couchbase, HBase and Cassandra.
• Led team of engineers and coordinated teh QA effort for prod-ops, QA and presentations to product and executive teams.
• Implemented high speed caching engine directly serving millions of customers when not possible prior.
• Teh caching engine built for parsing of JSON content over teh wire at nearly 100k per second requests.
• Designed a high speed proprietary NoSQL engine to serve as distributed cache wifin map-reduce.
• Defined data elements that were required for initial Big Data Platform
• Design initial data model & database design for NoSQL database solutions including Hadoop and In-Memory DB
• Oracle Golden Gate / Oracle Data Integrator / Hive / PostgreSQL Data integration design & configuration
• Oracle12C Enterprise Metadata Management installation and deployment
• Installation and Deployment – Oracle Enterprise Metadata Management for Hadoop / PostreSQL Data Store,
• Implement Talend Data Integration- Reading an input file, Transforming data, Combining columns, Joining data sources
• Implement Talend Data Integration- Creating database metadata, Joining data, Master Data Management model design
• Managed Rackspace and MS Azure accounts utilized for Big Data Platform
• Documented cloud strategy for Big Data Platform and showed value for use cases selected for project
• Architect & Administrator of Oracle EDW & SQL Server EDW (Replacing Informatica wif Big Data Platform)
• Oracle Data Integrator / Informatica / Hadoop / NoSQL – Data / ETL & replication for Bi-Directional updates
• Setup initial ETL design for Big Data Platform from Production EDW (Replacing Informatica wif Big Data Platform)
• Architect & Administrator Hadoop Cluster; Hadoop HDFS; Hadoop Hive; Hadoop Map Reduce; Hadoop Pig
• Documented process and data flow showing side by side comparisons of current ETL and Big Data Solution
• Architect & Administrator Hadoop Horton works, Hadoop Yarn, Talend Analytics (Replacing Informatica wif BD Platform)
• Moved more than 10 Billion rows of data into Big Data Plat form from Oracle EDW /SQL Server EDW
• Design SSAS cubes for data loads from flat file data sources (SQL 2012 SSAS)
• Management of Database Basics (Creating databases, managing transaction logs, sizing database and managing disk space usage and compacting database.
• Query tuning, table resizing, data file group reorganizations
• Managing database security (logins, roles, permissions)
• Manipulating database objects (tables, indexes, table data, creating table triggers, stored procedures)
• Data Transformation Services (Create packages, replication, transformations)
• Responsible for configuration and tuning of all SQL Server databases.
• Responsible for database file systems, device lay out and backup/recovery procedures ofSQL databases.
• Responsible for database sizing requirements.
• Responsible for data model and data dictionary maintenance of database.
• Responsible for setting up user security access to SQL Server database, excluding application-level access security which is administered by teh user.
• Interfaces wif Microsoft to resolve Microsoft SQL Server issues or problems.
• Tuning and performance of SQL Server Database. This includes teh development and implementation of automated alerts.
• Assist teh developers in tuningSQLqueries, Store Procedures/SSIS Packages.
• Develop/Document SQLServerStandards and Procedures.
• Distributed Transaction Coordinator Service (linked servers, remote servers, remote stored procedures)
• Replication (Snapshot, Merge, Distributor Administration, Managing Publications, Subscriptions)
• Database backup and recovery
• Creating and managing SQL Server Agents (Alerts, Operators, job schedules, notification)
• Database maintenance
• Review ERRECA SQL Server 2008R2 database, file system layout and patch level to determine areas of performance improvement
• Performance tuning exercises wifin SQL Server 2005/2008R2/2012 parameters
• Database Performance Tuning (query tuning, index tuning, application logs management, performance monitor Utilizing SQL Profiler primarily)
• Large data loads and updates (refresh’s) from production into development environment
• Setting up SQL Server Replication to relocate existing database reports onto a separate database to relieve some database performance for teh Online Users.

Confidential, New Providence, NJ

Oracle Database Administrator

Responsibilities:

• Lead Technical DBA for Identification and Resolution of Oracle Database /JD Edwards Performance Problems.
• Oracle 11g Rel 2Production Support / Financials, Manufacturing, Supply Chain &
• Oracle RAC (3 Node) Cluster Performance Tuning
• Performance tuning exercises wifin Oracle 11gR2 parameters
• Oracle Parallel Query Optimization and Performance Tuning
• Performance tuning exercises utilizing Oracle 11gR2 Indexing strategies (Automatic Database Diagnostic Monitor)
• Performance tuning on queries that were poorly performing to identify ways to improve response time and through put via Parallel Query and Table/Index Partition
• Oracle Database Server Performance Tuning
• Performed typical database and server maintenance and backup procedures
• Database Backup and Recovery and Disaster Recovery Design and Implementation
• Large data loads and updates from production into development environment
• Oracle Data Guard setup and DR Database Deployment wif Log shipping and Log Mining Setup

Confidential, Mount Laurel NJ

Lead Database Administrator / MS SQL Server DBA / MS Windows Server Admin / LUNIX-UNIX Support / Project Technical Lead

Responsibilities:

• 24X7 Database Production support as Operation DBA
• On Call support for 24X7.
• Proactively monitoring of live production databases in Microsoft environment.
• Troubleshooting of application issues, DB Performance issues and long running queries.
• Installation of SQL Server 2008 and its configuration and DB migration from SQL 2005 to SQL server 2008.
• Configuring, Monitoring and Troubleshooting DB Replication, Log shipping.
• Data Center Migration and Disaster Recovery plans and Implementation.
• Planning and implementation of database backup/restore Strategies.
• Writing customized scripts for monitoring of teh SQL Servers and other database administration work.
• Installation and configuration of various tools such as Spotlight, Job Manager and Foglight.
• Deployment of Production Builds. Deploying Build in Pre-prod environment and working wif QA team for Functionality Testing and Regression Testing.
• Database refresh in QA environment.
• Worked wif bi team and reporting group in generating teh weekly, monthly, and quarterly report by using SQL Reporting Services.
• Performance Tuning - Tune, analyze and optimize costly queries to reduce logical disk I/O for TEMPeffective performance.
• Review database architecture to determine areas of improvement
• Monitoring of server performance by profiler during peak periods of server utilization.
• Create and re-evaluate Indexes and made needed modifications for better performance.
• Perform proactive maintenance of all mission critical databases (small and large).
• Coordinates physical changes and performance monitoring of replicated production servers
• Create dtsx packages for data loads from flat files to SAS database (SQL 2008R2)
• Create dtsx packages for data loads from Webfocus flat files to Tableau database (SQL 2008R2)
• Project coordinator and technical lead for initiative to combine and automate ACH and Wire payment extracts from Microsoft Dynamics SL 7 to Wells Fargo CEO Payment Manager portal
• Developing project plans
• Review and sign off on project SOW from Well Fargo
• Manage project time line and resolve technical milestones
• Developing and maintaining critical issues documents.
• Conducting project status meetings
• Preparing all scope change documentation for Management approval
• Review functional specifications wif project developers
• TEMPEffectively communicate teh project vision to teh team
• Assign project plan tasks to team members
• Provide leadership and mentoring to project team members
• Upgrade UAT environment wif new application modules to support Wells Fargo format specs
• Modify relevant data tables to support global format changes
• Develop
• SQL Server 2000/2005/2008R2/2012
• Windows 2003/2008 32bit/64bit
• AIX Unix
• VMware
• Citrix 4.5
• Windows Shell/Batch Scripting
• Management of Database Basics (Creating databases, managing transaction logs, sizing database and managing disk space usage and compacting database.
• Query tuning, table resizing, data file group reorganizations
• Managing database security (logins, roles, permissions)
• Manipulating database objects (tables, indexes, table data, creating table triggers, stored procedures)
• Data Transformation Services (Create packages, replication, transformations)
• Responsible for configuration and tuning of all SQL Server databases.
• Responsible for database file systems, device lay out and backup/recovery procedures ofSQL databases.
• Responsible for database sizing requirements.
• Responsible for data model and data dictionary maintenance of database.
• Responsible for setting up user security access to SQL Server database, excluding application-level access security which is administered by teh user.
• Interfaces wif Microsoft to resolve Microsoft SQL Server issues or problems.
• Tuning and performance of SQL Server Database. This includes teh development and implementation of automated alerts.
• Develop/Document SQLServerStandards and Procedures.
• Distributed Transaction Coordinator Service (linked servers, remote servers, remote stored procedures)
• Replication (Snapshot, Merge, Distributor Administration, Managing Publications, Subscriptions)
• Database backup and recovery
• Creating and managing SQL Server Agents (Alerts, Operators, job schedules, notification)
• Database maintenance
• Performance tuning exercises wifin SQL Server 2000/2005/2008/2008R2 parameters
• Database Performance Tuning (query tuning, index tuning, application logs management, performance monitor Utilizing SQL Profiler primarily)
• Large data loads and updates (refresh’s) from production into development environment

Confidential, Philadelphia, PA

Technical Team Lead / Peoplesoft Administrator / MS SQL Server Database Administrator

Responsibilities:

• Lead technical team responsible for performing teh Peoplesoft Financials, HRMS and Global HRMS environment.
• Production Support / Test Support / QA Support / Development Support
• Performance tuning exercises wifin SQL Server 2000/2005/2008(R1/R2) parameters
• Performance tuning exercises wifin Oracle 11gR2 parameters
• Performance tuning exercises utilizing SQL Server Indexing strategies (Utilizing SQL Profiler primarily)
• Performance tuning exercises utilizing Oracle 11gR2 Indexing strategies (Automatic Database Diagnostic Monitor)
• Performance tuning on queries that were poorly performing to identify ways to improve response time and through put (Utilizing SQL Profiler –MS SQL Server & Automatic Workload Repository – Oracle DB)
• Database Performance Tuning (MS SQL Server & Oracle)
• Performed typical database and server maintenance and backup procedures
• Database Backup and Recovery and Disaster Recovery Design and Implementation
• Large data loads and updates from production into development environment