SUMMARY

• Gained strong experience in MS - SQL/SQL Server administration and over 6 years of DBA experience with a focus in production within PeopleSoft, Sybase, Oracle 10g/11g and other applications in the federal level.
• Implemented logical/physical database application design, configuration, installation, deployment and maintenance.
• Entrusted to run (SDLC) from collecting data, analyzing data, writing test scripts, creating test plans and administering test. Knowledge of Weblogic/BMC BladeLogic, ERP/Unix scripting and ITIL processes. I have delivered strong analytical/organizational skills and experience in providing technical leadership/quality.

TECHNICAL SKILLS:

• Microsoft Office Suites, Project, Access, BMC Remedy, Service Now, BMC Footprints, Adobe Acrobat
• PeopleSoft HRMS/HCM 8.2x/FSCM 9.x, Sybase ASE 12.5, SQL*Loader, SQL Optimizer, SSIS/SSRS,AIX
• MS Windows 98/2003/2007/ XP/Vista, Mac OS, Unix Solaris, Linux, Shell Script, MS IIS, Lync 2010/2013
• Oracle 10g/11g, OEM, TOAD, Grid Control, Service Desk Express, PowerShell, Quest STAT, Splunk, Netware
• VMWare/Hyper-V, XenApp 6.0, Citrix Client, XenDesktop, SQL Developer, SSL, Visual Studio, Oracle BI
• MS SQL 2005/2008R, MS Server 2003/2008, Exchange Server 2003/2005, SharePoint 2010/13, Sql*Plus
• TCP/IP, DHCP, DNS, LAN/WAN, CheckPoint/CiscoVPN, VERITAS Netback up, RMAN,PL/SQL,IBM Cognos
• Entrust PKI, PointSec Encryption, Firewall, MacAfee/Norton Anti-Virus, Cisco Routers/Switches, Visio, .NET
• NetIQ AppManager, SolarWind, Endpoint Security,SSH, Putty, WinSCP, Dell/HP Server, BMC tool, Qlikview
• MS SCOM, Microsoft Bitlocker, RedHat, Java script, HTML, XML, LDAP, PKI, IBM Endpoint manager

PROFESSIONAL EXPERIENCE:

System Database Specialist

• Provides data administration support for the development and maintenance of production/non-production database environments for distributed application. Creates, reset, and delete user SDE/domain accounts
• Configures and administers database system by deleting and modifying code to correct errors, lead the development of BMC service desk express platform, develop new and update SDE business rules process
• Ensures successful testing, implementation and transition to a production and operating environment after development. Communicates key business information to both management and our external customers
• Serves as the primary contact for support for any issues and requests submitted by the end users of Remedy applications. Troubleshoots user-related issues with the Remedy ITSM\maintained MS bitlocker
• Perform data extraction for weekly data import/load, execute DTS/SSIS packages for new user data record
• Support BMC Remedy ARS service request management (SRM) and ITSM Suite to include Incident, Change, Asset and (CMDB). Installed, configured and customize BMC FootPrints Service Core 12.x
• Manage routine ad hoc delivery schedule to ensure all reports are delivered on time and support the maintenance of BMC service desk express. Develop SDE business rules for system and email automations
• Supports Windows Server 2003/2008, provides application management and Server administration with network maintenance. Sets up database environments required for application development and testing
• Conducts routine hardware and software audits of workstations and Servers to ensure compliance with established standards, policies, and the configuration guidelines. Installs Symantec Endpoint Protection
• Monitors system event log, server log for possible issues, analyze the issues for resolution and implement solutions regarding database tables getting too large and data not being processed in a timely manner
• Troubleshoots COTS applications to identify and correct malfunctions as well as several other operational difficulties. Analyzes and suggest improvements to business processes with system architecture solutions
• Provide database monitoring, performance tuning and running query in SQL Server 2008 R2/SQL Server 2012 in 24x7 on call rotation. Perform Periodic SQL health check and capacity planning on data growth
• Perform database\software life-cycle activities to ensure utmost level of system performance\availability
• Create and execute SQL queries to add, update, move and/or remove data from the databases to complete work requested. Designed, test, debugs, documents programs and created job files for processing

Database Analyst

• Served as the database analyst delivering testing and production support in a deadline driven fast past environment and provided PeopleSoft applications support within Unix and Windows environments
• Conducted quality control and auditing of databases in a client/server environment to ensure accurate and appropriate use of data. Conducted analysis of business process flows to establish product processes
• Maintained and supported PeopleSoft component such as HCM, FMS and debugged PeopleSoft errors
• Served as a consultant and escalation point for issues and provides project manager with technical consultation and advice, enabling quick response to inquiries related to the program and projects
• Assisted in configuring ERP PeopleSoft CRM to meet each environment and/or installation's unique business requirements. Identified, analyzed, and interpret trends or patterns in complex data sets
• Supported all environments in the production chain and coordinated COOP process and recoveries
• Performed modifications to PeopleSoft HCM environments to support changes to the applications, report requirements, applied patches, responded to user requests, and troubleshot database application errors
• Executed test scripts, cases, and scenarios that determine optimal system performance according to specifications. Performed application testing such as system, unit, UAT, and regression testing methods
• Assisted in deploying custom configured applications into production including application Server deployments and configuration along with database schema updates/changes relative to version release
• Worked with functional team managers to develop detailed timelines for code migrations within the web based and IIS Server in production environment. Assisted with internal IT Audits and contingency testing
• Performed requirement analysis in documenting software requirements and change requests to support Sybase database within JPAS/DISA and respond to database related outages within the SLA timelines
• Collaborated with the application developers to isolate and solve design problems encountered during testing and deployment stages. Gathered and reviewed system data for capacity and planning purposes
• Monitored the operational databases at production sites for the purpose of identifying problems of database availability, efficiency, validity and security. Assisted in deploying Linux database scripts
• Created ad-hoc reports using Microsoft business intelligence SQL server Reporting services (SSRS/SSIS) and acted as a Subject Matter Expert in analyzing system requirements in response to project needs
• Ensured proper operation of extract, translate and load (ETL) process from multiple data sources including SalesForce, Dynamics GP, and other business applications. Administered and configured IBM Cognos

Technology Consultant/DBA Support

• Installed and tested new version of Oracle database management system (RDBMS) as well as supported database instance upgrades. Adjusted database size against performance and storage capacity levels
• Designed and implemented Oracle RDBMS solutions in accordance with client and data center standards, policies and methodologies. Performed after hours scheduled maintenance/release deployment activities
• Modified and executed SQL scripts for bug fixes and data repair and maintain security on databases and web applications. Managed database administration system within Oracle 10g/11g and MySQL database
• Provided appropriate consulting, interfacing, and standards relating to database management, monitored transaction activity and managed SQL database/applied security in Windows environment as required
• Developed patch management plan and applied patches to Oracle servers in a multi-tiered environment
• Performed weekly data import/export and performed Oracle database RMAN backup and recovery
• Managed database application releases in clustered and load-balanced environment to ensure system performance metrics, OLA and SLA are met. Created and managed CSV and XML imports and exports
• Participated in the implementation and release of database changes as submitted by the developer team and maintain Oracle 10g/11g production in RAC environment with ASM/Oracle partitioning
• Provided database administration support for production database including, creating tables, querying record, inserting\deleting records, modifying scripts for automation and customize Oracle BI Dashboard
• Provided support for Oracle WebLogic and Apache web server maintenance in production environment
• Created and maintain data file structures and use of system utilities to troubleshoot faulty database information. Loaded and extracted data from Oracle tables for ad hoc user requests and projects
• Performed network operation and maintenance, provided technical operational support for database deliverables, maintain COTS application products and Oracle database on Windows/Unix environments
• Utilized Solar winds and SCOM to monitor application, server, network, storage, CPU, Memory, disk space process utilization, restart services and reboot Servers as required to optimize system availability

System Administrator/PKI Support

• Provided database support for applications such as Microsoft SharePoint Portal Services and other COTS applications. Performed root cause analysis and problem resolution for Sybase and MS SQL databases
• Supported Windows Server 2003/2012, and Windows infrastructure components, IIS, HTTPS, SQL 2008/2012, DNS and VMware/Hyper-V. Recreate checkpoint(VPN) site, user account and RSA token
• Provided Tier 2/3 support on a multi-domain enterprise structure and maintain remote management of domain controllers, GPO, DNS, objects in AD, including backup, recovery and restoration of system
• Planned and coordinated deployment, monitoring, maintenance, development, upgrade and support of all IT systems\ERP, including, PCs, Unix Hosts, mobile device, Citrix Hosts, VMware and Citrix\SAP portal
• Provided support for SharePoint 2010 migration efforts to SharePoint 2013 with stakeholders while streamlining the migration process. Prepared reports for analysis of product failure trends/service issues
• Supported the upgrade of SQL server 2008R2\2012 migration of data from existing distributed Microsoft access databases to a centralized Microsoft SharePoint list, including maintaining business processes
• Managed SharePoint site, links and site collection features, functionality, accounts and user permissions
• Troubleshot issues with networks, websites, IIS, Servers, firewalls, Java, e-mail services and various application systems to determine cause/implement solutions to resolve problems in a timely manner
• Identified and maintained the best practices for BI system and software development, including data integration, data visualization, reporting, and data management. Administered QlikView data components
• Provided support on networking hardware, such as routers, switches, fiber optic cable and wireless network. Configured and troubleshot LAN/WAN, checkpoint VPN, wireless network & Entrust issues
• Administered Active Directory/LDAP user account creation, unlocking account, assisting in the datacenter configuration, adding computers to domain, setup RSA/entrust PKI and troubleshot web application server
• Participated in the implementation of PKI-level encryption with smart cards and/or tokens, certificate management, multifactor authentication, one-time passwords and support identity access management
• Provided PKI support to ensure authenticating users, producing and distributing certificates, maintaining, managing and revoking certificates. Administered Entrust PKI security manager/administration services
• Analyzed and evaluated network IPS, proxy logs for any compromise associated with workstation\server
• Supported security and compliance suite, lifecycle management, patch management and vulnerability assessment . Executed SQL script to query\modify data within a database and troubleshot Unix shell script
• Assisted in the migration of end users from a Novell environment to a Microsoft Active Directory environment using Quest migration tools. Analyzed and evaluate anomalous network and system activity
• Supported and troubleshot IBM BigFix management on Windows, Solaris, RedHat and created packages
• Perform monthly patches in accordance with established policies via lumensions, BigFix and managed code migrations . Performed end to end migration of accounts, groups, workstation file services and print