SUMMARY:

• Experienced in IT fields with diversified experience and demonstrated expertise maintaining operating systems & applications, providing technical support, and developing innovation solutions in alignment with business objectives.
• Experienced in System/DBA/Linux Administration under multi - platform environments installation and configuration, maintenance & troubleshooting. Proficient in handling many operating systems include Programming Language: C++, HTML, PHP and phyton. Operating System: Windows (XP, Vista,7 and windows 10 Versions), windows server 2003 and 2008. Database: MySQL server and Oracle.
• Proficient in Database Administration, Data Warehousing, Database Design and ETL Processes in the DEV, Test and PROD Environments.
• Expert in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities. Developed various T-SQL stored procedures and functions for Applications.
• Highly educated in various software & computer applications. Outstanding research, analytical and time management skills with the ability to maintain focus in demanding work environments. Strong ability to take on multiple challenges and complete assignments under pressure to meet stringent deadlines. Knowledge and adherence to software development best practices SDLC.
• Experience in Logical and physical modeling as well as Maintaining SQL Script for creation of database Objects and generating scripts using Erwin,Toad for oracle and MySQL workbench tool. Knowledgeable in Development, Configuration, Validation, Deployment and Requirements gathering. Created and implemented custom Bash shell for script to archive log files and to delete old archived files.
• Expert in Windows and Virtual infrastructure resources, System and Network administration, VMware Configuration & Administration, system Design, Data Center management, Data Center Migration, Implementation & maintenance of highly scalable 24x7 availability solutions.
• Proficient in System Integration, Administration with Windows Server 2003&2008, 2012 R2 Server, windows 98/XP/Vista/7 & Linux Red Hat.
• Highly educated in various software & computer applications. Outstanding research, analytical and time management skills with the ability to maintain focus in demanding work environments. Strong ability to take on multiple challenges and complete assignments under pressure to meet stringent deadlines. Knowledge and adherence to software development best practices including SDLC and JAD.
• Experienced in Development, Configuration, solutions evaluation, Validation, deployment and Requirements gathering.
• Experience customizing & designing SharePoint 2010 deployments while working productively in a fast paced environment.
• Experienced with UNIX/Linux Shell Scripting, java, .Net, MySQL/SQL, VB Script, Html/XML and C/C++/C# languages.
• Outstanding knowledge in Installation of Oracle with 9i, 10g and 11g on various platforms like Sun SPARC, LINUX, HP and Windows platforms and creating customized databases. Experience in writing UNIX and Linux Shell scripts to automate business process
• Proficient in developing and writing messages as diverse and complex ideas in concise and logical manner.

PROFESSIONAL EXPERIENCE:

Linux Administrator and DBA Administrator

Confidential, Washington, DC

• Expert on installation, Configuration and maintenance of Redhat Linux 6.X/7.X.
• Configured, Installed, modified and maintained systems and utility software on Linux Red Hat servers and configured legacy system.
• Monitored performance and resource utilization of key systems and applications. Provided ongoing trend analysis for forecasting future resource requirements. Performed Installations of Upgrades, Installation of Patches and Packages.
• Setup and administered network file system (NFS) to share data with Linux and across widow environment.
• Created and configured new users groups and Global Roles to authenticate, Created scripts to deploy applications from command line and automate log archiving. Worked closely with development team to troubleshoot ongoing issues in applications.
• Provided L2 production support for applications and Coordinated end to end application on boarding.
• Deployed WARS and EARS using Weblogic Admin Console and maintained Load balancing.
• Created Shell scripts to automate Cron jobs and system maintenance. Scheduled Cron jobs for job automation using autosys.
• Monitored application performance, Analyzed thread dump and heap dump for Weblogic application server.
• Researched and identified emerging application issues, Troubleshoot Weblogic Server connection pooling and connection manager. Configure and administered Connection pools for JDBC connections. Deployed applications on multiple WebLogic Server.
• Developed scripts (start, stop, backup & recovery processes) for WebLogic application server. Monitored log files and provided report.
• Performed UNIX System administration activities like stopping/starting services, rpm installations, and mounting/unminting file systems.
• Responsible for application changes across different platforms- development, testing and production environments.
• Managed escalations, creates/implements proactive measures, and reports progress to stakeholders.
• Managed and Assign tickets queue using BMC Remedy and Jira. Assigned, prioritized, suspended, escalated, and closed tickets. Reply to user's questions, and created a log tickets for any new issues. Created and configured applications in multiple environments DEV/TEST.
• Optimized queries and database performance using graphical tools SQL Profiler, Query Execution Plan, Index Tuning Wizard etc.
• Implemented High Availability & Disaster Recovery techniques like Always ON Availability Groups, Clustering (Both Active-Active and Active-Passive), Database Mirroring and Transactional. Identified data conversion and migration issues.
• Performed database troubleshooting, management, backup, restore and Point in time recovery.
• Performed database routine maintenance Re-indexing, Query tuning and performance tuning.
• Created T-SQL scripts for tables, views, functions, triggers and indexes.
• Imported/exported (Migrated) data between different sources like SQL/ Oracle/ Access/ Excel/ Flat Files using DTS, SSIS & BCP and Import/Export wizard. Created and maintained SSIS Package SQL Agent Jobs.
• Performed Installation and configuration of SQL Server 2008 R2 and DB migrations from SQL 2005 to SQL server 2008R2.
• Scheduled maintenance activities to vacuum, analyze to improve the query response time.
• Maintained custom vacuum strategies at table and database level. Tuning auto vacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples. Loaded data using SQL Loader and DB link tool.
• Leveraged enterprise business intelligence tools, SQL queries and other tools to develop complex models and reports.
• Generated parameterized reports, ad-hoc reports, sub reports, tabular reports using SSRS. Created functional technical specifications.
• Provided L2 production support for applications and Coordinated end to end application on boarding.
• Advised team members on the most efficient database designs and helped in writing complex queries.
• Provided 24/7 Production Support for the maintenance & scheduling of reports.
• Created and configured applications in multiple environments DEV/TEST/PROD.

Database Administrator

Confidential, Washington DC

• Created functions and developed procedures to implement application functionality at the database side for performance improvement, involved in Performance tuning of Queries, Indexes and Stored Procedures using SQL Profiler.
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services. Experience in designing Database Models for creating tables, indexes, optimizing views using MS Visio.
• Designed and developed SSIS Packages to extract data from various data sources such as MS Access database, Excel spreadsheet, and flat files into SQL server 2012 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Responsible for entire Business Intelligence development lifecycle, using Microsoft SQL Server Reporting Services 2008 R2, and using BIDS Business Intelligence Development System. Developed SSIS packages to export data from OLTP database to OLAP database.
• Worked with Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart.
• Monitored database status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities.
• Monitored daily health checkups various production database servers. Verified backups and error logs on the servers and troubleshoot.
• Perform day-to-day database and ETL administration to ensure integrity, security, optimization and availability of the supported systems.
• Monitoring the servers by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Tuning Advisor. Refresh Database as per the requirements of the clients.
• Created SQL server agent jobs, alerts and notifications to proactively monitor database and server level, configuration, schema and data changes. Managed Database Log File Size and Virtual Log Files (VLFs)
• Provided 24/7 supports through on call rotation for PROD and NON-PROD Environments.
• Responsible for troubleshooting SQL Server production issues and managing SQL Server security and logins.
• Interacted with internal and external users to provide technical support for our client's developed applications.