PROFESSIONAL SUMMARY:

• Gained strong experience in MS-SQL/SQL Server administration and over 5 years of DBA experience with a focus in production within PeopleSoft and Oracle 10g/11g applications for the federal government.
• Implemented logical/physical database application design, configuration, installation, and maintenance
• Entrusted to run SDLC from collecting data, writing test scripts, creating test plans, administering test, and updating/maintaining database. Knowledge of Weblogic/BMC BladeLogic, ERP/Unix scripting, .NET
• Proven track record operating in a highly scalable 24x7 web-enabled database applications, Microsoft Exchange Server 2003/2007, Oracle APEX, Service Oriented Architecture SOA ,VMware ESX, AIX
• Delivered strong analytical/organizational skills and experience in providing technical leadership/quality

TECHNICAL SKILLS:

• Microsoft Office Suites, Project, Access, Visio, BMC Remedy, Adobe Acrobat, Printers, Visual Studio
• PeopleSoft HRMS/HCM 8.x/FSCM 9.x, Sybase ASE 12.5, PL/SQL, MySQL, SSIS/SSRS, Sql developer
• MS Windows 98/2003/2007/XP/Vista, Mac OS, Unix Solaris, Linux, Shell Script, People Tools, Winscp
• Oracle 10g/11g, OEM, TOAD, Grid Control, BMC Service Desk Express, Application Builder, Lync2010
• VMware 4.X, XenApp, Citrix Server, SQL Optimizer, SQL Loader, PS query, LANDesk, XenDesktop
• MS SQL 2005/2008R, SharePoint 2010, MS Server 2003/2008, Exchange Server 2003/2005, SQL Plus
• TCP/IP, DHCP, DNS, LAN/WAN, CheckPoint/CiscoVPN, Citrix Client, VERITAS Netback up, RMAN
• Entrust PKI, PointSec Encryption, Firewall, MacAfee/Norton Anti-Virus, Cisco Routers/Switches, SSL
• NetIQ AppManager, SolarWind, Endpoint Security, Crystal Report X, Putty, XML, C, Java, Web Services

PROFESSIONAL EXPERIENCE:

Confidential

System Database Specialist

• Provides data administration support for the development and maintenance of production/non-production database environments for distributed applications. Creates, change, and delete user accounts per request.
• 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 internal customers
• Performs data extraction for weekly data import/load, execute DTS/SSIS packages for user data records
• Troubleshoots COTS applications to identify and correct malfunctions as well as several other operational difficulties. Analyzes and suggest improvements to business processes with system solutions
• Manages 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/email automations
• Supports Windows 2003/2008 Servers, provide 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 configuration guidelines. Installs Symantec Endpoint Protection
• Administer application data process queries and reports as requested by users, and monitor server logs to ensure that all system transactions are processed correctly. Provide communications relating to outages
• Perform extraction, transformation and loading ETL data sets using SDE integration console system
• Configure and perform incident management, service request, problem management and change request
• Provides on-call support for any database operations and applications issues/activity in 24x7 environments

Confidential

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 environment
• 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
• Developed, coordinates and implements plan to test business and functional processes during system development and quality assurance testing. Prepared tape backup and performed Symantec Backup Exec
• Assisted in deploying custom configured applications into production including application server deployments and configurations along with database schema updates/changes relative to version release.
• Collaborated with the application developers to isolate and solve design problems encountered during testing and implementation stages. Gathered and reviewed system data for capacity and planning purposes
• Utilized Mercury Quick Test Professional QTP for testing and performed application test changes by executing test scripts, setting up test scenarios, validating process results and applied lessons learned
• Monitored and troubleshot ETL processing system exceptions across the development, QA, production environments. Participated in code reviews and ensure the code written complies with the requirements
• Performed modifications to PeopleSoft environments to support changes to the applications, report requirements, applied patches, responded to user requests, and troubleshot database application errors
• Performed system testing of creating and executing automated test scripts in support of Oracle database in both development and a production environment. Assigned database roles and privileges to users
• Performed database and Software Life-Cycle activities to ensure premier level of system performance and availability. Performed database query to prevent data duplication, delete obsolete data and fix bad data
• Created ad-hoc reports using SQL server Reporting services SSRS/SSIS and acted as a Subject Matter Expert in analyzing system requirements in response to project needs and perform data access audits.

Confidential

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
• Modified and executes SQL scripts for bug fixes and data repair and maintain security on databases and web applications. Managed database administration system for Oracle 10g/11g and MS-SQL database.
• Provided appropriate consulting, interfacing, and standards relating to database management and monitors transaction activity and performed acceptance testing across client's enterprise platform.
• Coordinated with database architects in analyzing automated workload reports AWR from Enterprise Manager Grid Control , tuning system to improve database response times. Developed SOP documents
• Maintained and modified automation scripts to capture database security threats, unauthorized access, DDL and DML activity in production databases. Modified PL/SQL functions to support database system
• Supported and maintain Oracle 11i E-Business Application Builds/ Releases Repair Operations and develop back-up, recovery procedures and data archive/purge procedures. Perform Oracle APEX patches
• Performed network operation and maintenance, provide technical operational support for database deliverables, maintain COTS application and Oracle database on Windows/Unix environments.
• Managed database application releases in clustered and load-balanced environment to ensure system performance metrics, OLA and SLA are met. Administered Microsoft SQL 2008 database environments
• Participated in the implementation/release of database changes submitted by the dev team and maintain Oracle 10g/11g production in RAC environment with ASM/Oracle partitioning. Perform RMAN backup
• Provided database administration support for the production of databases including, creating tables, inserting records, database performance tuning and modified scripts for system automation
• Utilized Oracle Grid Control OEM and creation of custom notifications to monitor and manage Oracle and Unix targets. Monitored Alert Logs, backups, Oracle objects, file server space and NetApp storage system
• Maintained security database files, tables and systems used to provide security related services for various platforms and applications. Performed vulnerability, threat analysis, security auditing, incident response

Confidential

System Production 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
• Researched and answered questions involving functionality in various versions and modules of PeopleSoft application. Maintained logs monitoring support for client/server, network operations and production
• Reviewed database error, diagnose, troubleshot, and suggest course of action and/or implement solutions
• Assisted in risk assessment duties including reporting and oversight of remediation efforts and change control. Detected and supported in security incidents and events to protect corporate and federal assets
• Supported Windows Server 2003/2012, Active Directory, and Windows infrastructure components, IIS, SQL 2008/2012, DNS and VMware ESX 5. Recreate checkpoint VPN site, user profiles and RSA token
• Coordinated and executed all required system updates to include the application of patches to the VMware systems hosting infrastructure and perform audit trail analysis in Internet misuse monitoring.
• Monitored and analyzed network traffic via multiple sources, anti-malware, firewall, syslog IDS/IPS, etc.
• Designed and implemented network security components to efficiently mitigate any threats or attacks
• Maintained security level compliance with applicable federal directives and policies regarding securing and monitoring of information. Develop basic IDS / IPS rules to identify and/or prevent malicious activity
• 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
• Provided remote assistance in day-to-day operation of multiple data centers consisting of multiple LAN servers for MD and VA offices. Managed virtual servers to include Web, SQL, WINS, Files, and Citrix
• Created SharePoint Web applications/Site Collections and configured SharePoint services/settings

Confidential

IT System Administrator

• Administered Active Directory services of creating user accounts, unlocking accounts, assisting in the configuration, maintaining group policy, joining computers to the domain, and setup RSA/entrust PKI
• Performed systems architecture and PKI support on the PIV certificate issuance systems, and Active Directory system to include managing server hardware, switches, server operating system, and Entrust CA
• Managed SharePoint end user accounts, permissions and access rights in accordance with best- practices regarding privacy and security. Maintained cloud administration of SharePoint server
• Provided support for both internal and external End-User Customers and resolve BMC remedy tickets
• Communicated alerts to agencies regarding intrusions and compromises to network infrastructure, applications and operating systems. Evaluated firewall change requests and assess organizational risk
• Performed periodic and on-demand system audits and vulnerability assessments, including user application access, access control, external Web browsing, firewall audits, and developed incident report
• Performed routine production and non-production administration, monitoring and troubleshooting, as well as provide escalation level support to remote data centers. Produced data center project status reports
• Installed and configured system hardware and software, upgrading/patching software, perform backup and recovery tasks. Handled incident tickets/problem ticket and provided resolutions via Remedy system.
• Monitored the status and cycle process of Data Center systems and server to ensure production completion
• Developed database disaster recovery DR and disaster recovery site documents for all database systems
• Managed weekly backups of the databases to minimize risks to operational down time and recovery
• Coordinated server installation, upgrades for the hardware and software applications to ensure compliance within FDCC requirement, and review/analyze the critical patch update to administer patch managements
• Troubleshot and maintained Microsoft Exchange 2005/2007 servers and all related messaging components
• Configured and troubleshot LAN/WAN, checkpoint VPN, wireless network, Citrix server, switches/router