PROFESSIONAL SUMMARY

• Gained strong experience in MS - SQL/SQL Server administration and over 8 years of DBA experience wif a focus in production wifin PeopleSoft, Sybase, Oracle 10g/11g, data center and other application 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. Experience in providing technical quality\leadership

TECHNICAL SKILLS:

• Microsoft Office Suites, Access, BMC Remedy, Service Now, Adobe Acrobat, Redhat, Chef client
• PeopleSoft HRMS/HCM 8.2x/FSCM 9.x, Sybase ASE 12.5, SQL*Loader, SQL Optimizer, SSIS/SSRS, Apache
• MS Windows 98/2003/2007/XP/Vista, Mac OS, Unix Solaris 9v, Linux, Shell Script, MS IIS, Lync 2010/2013
• Oracle 10g/11g, OEM, TOAD, Grid Control, PowerShell, Quest STAT, Wireshark, WebSphere, Cywgin, SoapUI
• VMWare/Hyper-V, XenApp 6.0, Citrix Client, XenDesktop, SQL Developer, SSL, Visual Studio, Oracle BI, Git
• MS SQL 2005/2008R, MS Server 2008/2012, Exchange Server 2003/2005, SharePoint 2010/13, Sql*Plus, AIX
• 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 8.2, SolarWind, Endpoint Security, SSH, Putty, WinSCP, Dell/HP Server, BMC Tools, PKI
• MS SCOM, Java script, HTML, XML, LDAP, IBM Endpoint manager, Oracle Fusion Middleware, SNMP 2

PROFESSIONAL EXPERIENCE:

Confidential, Calverton, MD

Application Technology Architecture Associate Manager

Responsibilities:

• Interact wif senior management levels at a client and/or wifin Accenture, which involves negotiating on significant matters. Provide troubleshooting support for Citrix VDI infrastructure & virtual desktops
• Provide full estimations of delivery effort across all areas of design, build, test and rollout activities
• Engage wif product owners and business users as well other technologists in analyzing functional and non-functional requirements to halp support application design decisions. Review and approve timesheet
• Assisted in the implementation of the information systems that support the enterprise infrastructure of the organization. Perform ping test to validate firewall port if it is open or not using PowerShell scripts
• Participate in meetings regarding projects, hosting and data center services, product evaluations, and other activities. Perform information assurance vulnerability alert & host based security system (HBSS)
• Collaborated wif the application developers to isolate and solve design problems encountered during testing and deployment stages. Gatheird and reviewed system data for capacity and planning purposes
• Deployment and operational support of (pre-production, production, and development) environments for multiple project using WebLogic application. Document process & procedures as it relates to the system
• Administer IIS web servers, Java, SoapUI and coordinate wif business users to schedule maintenance
• Install and configure, WinScp, Cywgin wif SSH host module for files and data import/export process
• Install and configure SQL developer, Oracle Access Manager in Windows Server 2012 environment
• Perform daily and weekly patching of software and various tools in VMs and VDI environment
• Provided support for Oracle WebLogic and Apache web server maintenance in production environment
• Participates as needed in all phases of software development wif emphasis on the planning, analysis, testing, integration, and documentation. Analyzes and trouble-shoot Mid-tier and infrastructure issues

Application System Monitoring

Confidential

Responsibilities:

• Installed and configure Toad for Oracle 11, Informatica power Center Workflow monitor for production monitoring environment. Configured applications wifin Microsoft SQL Server 2008R2/2012
• Identified requirement, design and coordinate the implementation of solutions to major hardware\software projects wifin the platform environment. Created project plans and performed training when applicable
• Followed up for file arrivals, monitor job runs, follow up job failures and late runs, execute Unix script to kick start jobs, handle file by identifying and using prior run files to complete current run
• Configured web/database/mail/ftp servers, SSL Certificates, Linux/Windows user accounts and prepare/execute Oracle SQL queries. Install\configure software components, Putty WinSCP and SSH
• Assisted in implementing database changes in response to changes in the customer’s enterprise computing environment, such as new versions/releases of system software and perform database routine maintenance
• Troubleshot issues and participate in on-call support, ensuring the stability and performance of the production environment. Performed query via SQLplus, queries/commands in Oracle databases
• Reviewed logs execute scripts in UNIX environment, and monitor application and infrastructure performance. Configured benthic software, DBeaver, IBM Websphere MQ, and Java development kit
• Troubleshot COTS applications to identify and correct malfunctions as well as several other operational difficulties. Analyzed and suggested improvement to business processes wif system architecture solution
• Perform requirement analysis to support Windows Server/NetIQ AppManager/meeting wif service owner
• Assisted in developing and testing disaster recovery procedures and troubleshot windows\Linux Servers
• Perform startup/shutdown, logs verification for application, troubleshooting system issues and tracking them across different components. Supported WebSphere portal & Web content manager platforms
• Developed business cases for data quality improvement and support SAP application/Data services
• Provide responses to client requests via phone, email by utilizing ServiceNow to track production tickets (daily/weekly/monthly tickets received, tickets closed, tickets pending, etc.), and update shift log

Database Specialist

Confidential, OP

Responsibilities:

• Provided 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
• Configured and administered 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
• Ensured successful testing, implementation and transition to a production and operating environment after development. Communicated key business information to both management and our external customers
• Served as the primary contact for support for any issues and requests submitted by the end users via Remedy system. Troubleshot user-related issues wif the Remedy ITSM\maintained MS bitlocker
• Performed data extraction for weekly data import/load, execute DTS/SSIS packages for new user record
• Supported BMC Remedy ARS service request management and ITSM Suite to include Incident, Change, Asset management and (CMDB). Installed, configured and customize BMC FootPrints Service Core 12.x
• Installed Windows Server 2003/2008, provided application management\Server administration support
• Conducted routine hardware and software audits of workstations and servers to ensure compliance wif established standards, policies, and the configuration guidelines. Installed Symantec Endpoint Protection
• Assisted in supporting a SQL server multiple named instance environment operating on a multiple node failover cluster (Microsoft Clustering Services). Responded service requests from application developer
• Provided database monitoring, performance tuning and running query in SQL Server 2008 R2/SQL Server 2012 in 24x7 environment. Performed Periodic SQL health check and capacity planning on data growth
• 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
• Created\executed SQL query to add, update, delete data from the databases to complete work requested
• Administered system configuration management of OS installation, security updates, identify and troubleshot hardware components that are problematic. Reviews system logs and application logs

Database Analyst

Confidential

Responsibilities:

• Served as the database analyst delivering testing and production support in a deadline driven fast past environment and provided PeopleSoft\Sybase applications support wifin Unix\Windows environments
• Served as a consultant and escalation point for issues and provides project manager wif technical consultation and advice, enabling quick response to inquiries related to the program and projects
• Promoted the development of technical infrastructure and standards to enable delivery to business domains and support systems networking, integration, portal, Java, data warehousing in Windows/Unix
• Assisted in troubleshooting and testing the Oracle Fusion Middleware applications and the Intercede credential management system. Supported Java container administration wifin WebLogic environment
• Maintained system passwords to include servers, hardware security modules (HSM), administrative card sets, workstations, network infrastructure, and applications related to the system/supported JIRA
• 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
• Performed configuration and administration of middleware platforms (me.e. IBM WebSphere, IBM MQ, Tomcat web server and setting proxy for Middleware systems)
• Maintained secure system access, monitoring, control, and evaluating; establishing and testing disaster recovery policies; completing back-ups; maintaining standard operating procedure documentation
• Performed WebShere MQ System Management, performance tuning, troubleshooting and maintenance
• Assisted in configuring\testing modules of Oracle Middleware identity management such as OIM\OAM
• Installed and assisted in enterprise application integration wif RabbitMQ, SAP applications for asynchronous delivery of data for messaging solutions\participated in agile methodology environment
• 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
• Worked wif functional team managers to develop detailed timelines for code migrations wifin the web based and IIS Server in production environment. Assisted wif internal IT Audits and contingency testing
• Monitored the operational databases at production level for the purpose of identifying problems of database availability, efficiency, validity and security. Assisted in deploying Linux database scripts
• Installed and configured COTS applications in a multi-tier environment, including integration wif ERP/Sybase applications. Supported availability of Oracle IdAM services wifin O&M environment

Technology Consultant/DBA Support

Confidential

Responsibilities:

• Installed and tested new version of Oracle database management system (RDBMS) as well as supported database upgrades. Adjusted database size against performance and storage capacity levels
• Designed and implemented Oracle RDBMS solutions in accordance wif client and Company 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 databases\web applications security. Managed database administration system wifin Oracle 10g/11g and MySQL database system
• Assisted in troubleshooting and testing Oracle fusion Middleware applications \ Oracle enterprise manager and DHS credential management system. Assisted in developing and updating SQL queries
• Provided appropriate consulting, interfacing, and standards relating to database management, monitored transaction activity and managed SQL database in Windows and Linux environments as required
• Developed patch management plan, applied Oracle patches, perform Oracle RMAN backup and recovery
• Managed database application releases in clustered environment to ensure system performance and assisted in administering database mirroring. Created/managed CSV and XML imports and exports files
• Participated in the implementation and release of database changes as submitted by the developer team and maintain Oracle 10g/11g production in RAC environment wif ASM/Oracle partitioning and OEM
• 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 systems in production environment
• Monitored and troubleshot Oracle fusion middleware, third party application servers, and other web services manually. Provided on-going oracle administration and technical infrastructure maintenance
• Ensured proper operation of extract, translate and load (ETL) process from multiple data sources and other business applications. Integrated and maintained application via Software Development Life Cycle SDLC
• 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

System Administrator/PKI Support,

Confidential

Responsibilities:

• Provided database support for applications such as Microsoft SharePoint Portal Services and other COTS applications. Performed root cause analysis and problem resolution for 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
• Supported the performance/capacity planning information recommend and plan platform system, CPU, memory, and disk upgrades. Assisted in creating\deploying packages via SCCM in Windows environment
• Assisted in supporting and monitoring the operations of SQL databases on VMware servers and on non-virtualized servers. Configured virtual desktop Infrastructure (VDI) and Windows 7/8 Enterprise Desktop
• Assisted in coordinating deployment, monitoring, maintenance, development, upgrade and troubleshot IT systems\ERP, including application, Unix Hosts, Citrix Hosts, Entrust, VMware and Citrix portal
• Supported enterprise storage across server technologies (e.g., Windows, Solaris, Red Hat, AWS) and implemented operational best practices. Supported IBM mainframe wif z/OS Operating System
• 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
• Troubleshot issues wif networks, websites, Servers, firewalls, Java, e-mail services and various web application systems to determine cause and implement solutions to resolve problems in a timely manner
• Assisted in single sign on of HSPD-12 PIV authentication and implementation of identity federation of enterprise directory architecture and Design including directory schema, namespace and replication
• 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
• Performed database security, remote device communications, enterprise storage, and enterprise backup technologies. Troubleshot network, such as routers, switches, wireless and LAN/WAN systems
• Provided PKI support to ensure authenticating users, producing and distributing certificates, maintaining, managing and revoking certificates. Administered Entrust PKI security manager/administration services
• Analyzed, monitored and evaluates network IPS, detailed firewall, and proxy logs for any compromise associated wif workstation vulnerabilities. Prepared incident reports of analysis methodology and results
• Performed Windows server infrastructure management of Active Directory and SQL Server installation, configuration. Performed patches in accordance wif company policy via lumensions and WSUS system
• Performed 24x7x365 monitoring for network resource outages and enterprise/data center applications, servers and supported virtualized datacenter and maintain security compliance, Avaya\VOIP systems
• Supported and troubleshot IBM BigFix management on Windows, Solaris, RedHat\ push packages