OBJECTIVE:

To take up a challenging and rewarding career in a reputed organization providing IT support and effectively contribute towards the goals of the organization.

SUMMARY:

• 15+ years of experience in IT industry with experience in Database/System Architect, Data Model and Software Configuration Management (SCM). Extensive experience includes SCM, Build/Release Management, and Change/Incident Management.
• Implementing Software Configuration Management processes on projects including setting up and supporting our Continuous Integration. Build environment by automating Software builds, release and configuration processes.
• Management experience supervising systems, database and security admin personnel.
• Extensive experience with hands - on IT systems management supporting environments using KVM, Linux, OpenStack, Cisco, F5, UNIX and Windows environments including shell and Python scripts, perforce, SVN (Subversion), Perforce, GIT, Build forge and TFS. Experience operating with both internal and colocation data center environments.
• Experience with real world healthcare data, such as MarketScan, Optum, PharMetrics, Medicare and/or EMR databases
• Experience on databases with Patches/upgrading and dealing with concurrent systems.
• Managed Azure services and subscriptions using Azure portals and PowerShell, managed Azure resources to Azure Resource Manager Azure virtual Networking - Implemented Virtual Networks using deployment template, Azure portals and PowerShell, configured intersite connectivity, point to site VPN, site to site VPN, VNet to VNet VPNS. Configured connectivity between IaaS v1 VNets and IaaS v2 VNets
• Azure Availability and Scalability - Configured VMs availability sets using Azure portal to provide resiliency for IaaS based solution and scale sets using Azure Resource Manager to manage network traffic Azure Storage Planning - Migrated Blob Storage for document and media file, Table storage for structured datasets, Queue storage for reliable messaging for workflow processing and file storage to share file data.
• Managed environments DEV, SIT, QA, UAT and PROD for various releases and designed instance strategies.
• Experience working in an agile environment (Scrum, Kanban, XP, etc.)
• Ensure that infrastructure meets our compliance obligations (HIPAA, PCIDSS)

AREAS OF INTEREST:

• Sql Server
• MongoDB (Sharding
• Replica Set)
• Window Server
• Linux/Solaris
• AS400
• ES2
• S3
• VMware vShare
• ESXi
• AZURE
• GIT
• Ansible
• BigData Hadoop
• Splunk
• EMC
• ETL Tool -Pentaho
• Tableau
• HPQC
• Weblogic
• SVN
• Apache
• Citrix Xen
• Oracle/ Sybase 15.7/Mysql/DB2
• Golden Gate
• Java
• Software Quality Analysis
• Bladelogic
• Splunk
• Tripwire
• GIT.

TECHNICAL SKILLS:

Operating System: UNIX, Linux, Windows, Solaris, Mac.

Technology: Build and Release Management /Quality Testing/ OBIEE, DevOps, Amazon Web Services (AWS).

Languages: C, C++, Java/J2EE, Perl Scripting, Unix Shell Scripting, SQL.

Tools: SVN, GIT, GCC, Clear Quest, ANT, Maven, Chef, Puppet, Gradle, Jenkins, Anthillpro Quick Build, CVS, MAKE, PVCS, Rational Buildforge, TFS, SSH/SSL, Awk, Sed, LDAP, Atlasian Product like (Jira, Bamboo, Fish Eye).

Server: WebSphere, Weblogic, Apache Tomcat, JBoss.

Database: MySQL, MS SQL Server, Oracle9i/10g, MS Access.

Web Application: HTML, JSP, Servlets, JSF, XML, CSS, JDBC, Struts, Spring.

PROFESSIONAL EXPERIENCE:

Confidential

Data Manager

Responsibilities:

• Responsible for managing Development, Test, QA and Production databases and implementing future enhancements through daily SCRUM meetings, Kanban and Slack to meet the business needs of the end users.
• Work with the Dept of VA to develop an enterprise data management strategy and roadmap, master data management/data governance plan, data migration, data conversion and data cleansing strategies, legacy system phase-out plan and Business Intelligence solutions. Document the As-Is system functions which will be retired through the implementation of the program, evaluate the To-Be business and technical requirements and translate into specific data solutions
• Created queries and combined multiple databases from a variety of sources using Microsoft SSIS and Tableau tools. Tracked and reported status and progress of data management. Resolved any database-related change that affected the database’s availability, usability and accuracy. Analyzed data quality issues, made recommendations on data quality initiatives.
• Design comprehensive solutions for diverse business requirements related to DW/BI and lead a team to achieve project goals. Analyze current analytical and reporting environments, recommend strategies and build roadmaps to achieve project goals. Develop data management strategies including master data management, data quality and data governance. Develop an implementation plan and work with the project management to track progress.
• Leads the creation of or creates design documents that ensure consistency in development across the IT organization. Leads the definition of architecture to ensure that the organization's solutions are built within a consistent framework. Provides expertise and guidance to groups across the enterprise in the design and support of architecture and infrastructure solutions for business applications.
• Developed and supported the Software Release Management and procedures. Performed all necessary day-to-day Subversion support for different projects. Responsible for design and maintenance of the Subversion Repositories and the access control strategies.
• Lead in Designing, implementation, and maintenance of database systems. Install, upgrade, and support Cache database application environments. Provide product function, design, build, and support expertise and experience for ongoing system build and configuration. Work with application end users, analysts and experts in to build, configure, deploy, implement, operate, support, and maintain the database. Develop, support and maintain required system design and build documents and other project documentation.
• Created the branches in Subversion to implement the parallel development process to support quarterly releases. Merged release branches to the trunk after the production release and resolved the conflicts rose during the merge in Subversion.
• Direct and participate in the analysis effort for source-to-target data mapping documentation, for logical and physical models development using Erwin, Oracle, for the development of dimensional and ETL staging models that adhere to data warehouse best practices and comply with CMS and state standards that include maintaining physical and technical security and privacy of protected health information (PHI) mandated by HIPAA.
• Worked closely with development team and SQA team for product releases. Worked as a system administrator for the build and deployments process on the enterprise server.
• Documented project's software release management procedures with input decisions. Created runbooks for each application to help the release management team for successful deployments.
• Responsible for career development/planning, performance and pay discussions of team members

Confidential

Staff, Database Admin

Responsibilities:

• Responsible for Installations and Maintaining Prod/nonProd environments for Oracle RAC/Standalone 11g and implementing 12c, SqlServer 2005/08/12, MongoDB, Sybase ASE/IQ databases, DB2 including ASM, Dataguard, goldengate RAC/Standalone, Replication/Mirroring & Cluster Server on UNIX and NT.
• Teamup with SAN team to get more space for production and nonproduction servers.
• Monitor database health - availability, reliability, performance, capacity planning, server clustering, replication, re-indexing. Tune system to ensure maximum system efficiency and 100% system availability. Resolve any problems that arise with the database
• Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, and Prod env.
• Managed day-to-day User activities like creating logins, granting permissions, applying security for new users, manually running the batch jobs through Control-M tool.
• Installing, upgrading and applying the latest service packs/hot fixes.
• Design and developed Oracle PL/SQL Scripts for Data Import/Export, Data Conversions and Data cleansing.
• Solaris 11.2 Operating system support and expertise -- zones, OVM, patching, performance tuning
• Install and configure OVM 3.3.1 on Linux and Solaris -- setup all Oracle products, tune, setup SAN, network VLAN. Provided High availability through Clustering, Mirroring, Replication.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Extract, Transform and Load data using SSIS. Create triggers to keep track of changes to the fields of tables when changes are made.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction. Provide database coding to support business applications using T-SQL. Develop a business continuity plan for the SQL Server Databases
• Create triggers to keep track of changes to the fields of tables when changes are made. Develop reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures. Configure and maintain Report Manager and Report Server for SSRS.
• Generate reports with Microsoft SQL Server Reporting Service and Crystal Report. Created scripts using C# as debugging tool and transform input data. Install, configure and maintain MS SQL Server 2008 and 2012. Plan, design, and implement application database code objects, such as stored procedures and views.
• Provide database coding to support business applications using T-SQL.Handled the Back up and Restoration Strategy, Executed Shell Scripts using Cron jobs, Perl, Python scriting, Planned and scheduled Backups, took Logical Backups (usingRMAN, Import/Export, Hot/Cold Backups, Data Pumptools).
• Work within the production support team and maintain operational consistency and efficiency.
• Daily, weekly system and DB server maintenance like cleaning the old archives, validating the backups, monitoring Alert Logs & Trace file and Application Logs, managing the security at user level and at application level.
• Solid experience inmanaging Oracle inHigh Availability environments using Real Application Cluster, Failovers, Data Guard and Cloning technologies.
• Upgrading of Database from lower version to higher version. Installation of Patch and fix bugs.
• Administrating Database in various platforms like WINNT / 2000/ 2003, SUN SOLARIS 8/9, HP UNIX, Red Hat Enterprise Linux .
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skill.

Confidential

Sr.System Engineer

Responsibilities:

• Maintaining a high-availability data center of approximately 2000 physical and virtual servers(ESXi) running Oracle Solaris 10, AS400, AIX, Red Hat Enterprise Linux 5/6 and Window Servers IIS using V Cloud Director, PowerShell scripting, Perl, Python . Providing LAMP support for production, Citrix XenApp server support, apache server administers, troubleshooting Splunk running on servers, development and test environments employing Oracle/Sybase and Microsoft SQL Server databases.
• Lead team in building out and maintaining high performance, high availability environment, using virtualization and open source solutions where possible.
• Replaced existing manual deployment and management processes using Hudson Jenkins, GIT, Ansible for automate deployed on Production and non-production environment.
• Migrating a production infrastructure into on-premises to Azure Cloud and created customer images for VM's. Deployed clusters using Json template and power shell in AZURE. Created a cloud build environment. AZURE administration. Installed, configured, administered, monitored Azure, IAAS and PAAS, Azure AD. Used Windows Azure portal to manage Virtual Network and Traffic Manager. Created, managed, monitored VM using Windows Azure portal admin. Created, managed, monitored Web site using Windows Azure portal admin
• SQL server 2014, 5.0-installed, configured and administered and created Geo databases using GeoReplciation. Supported and deployed network in a multi-vendor environment including Cisco, 3Com routers, switches, and remote servers. Trouble-shooted issues regarding overall connectivity to network server, email clients, and enterprise messaging systems
• Provide technical support for internal computer problems and customer problems. Configured and supported inter-office networks and file servers. Configure LAN/WAN hardware of all types including desktops and printersInstalled and Configured Jenkins for Continuous Integration. Used Jenkins to perform automated Builds and Deployments. Expert in User Management and Plugin Management for Jenkins.
• Build, configured and support Application team environments. Deployed the applications to Tomcat Application Server and static content to apache web servers. Established processes and tools to maintain code base integrity, including check-in validation rules and branch/merge processes.
• Used services deploy command for building the web services. Used maven for few modules.
• Supervising the team during the On call week for production and non-production applications, servers and databases related issues. Mentoring Level 2 for any production or non-production issues.
• Worked on Zabbix monitor tool setup for monitoring our applications and Linux vm's. Worked on creation of puppet manifest files to install tomcat instances and to manage configuration files for multiple applications.
• Written Chef Recipes to automate our build/deployment process and do an overall process improvement to any manual processes.
• Written multiple cookbooks in Chef. Implemented environments, roles, databags in Chef for better environment management.
• Worked on creation of Change requests and Service requests using tool Service Now. Environment: SVN, GIT, Maven, Gradle, Jenkins, AWS, Nexus, Tomcat, Apache, Puppet, Chef, Find Bugs, Cobertura, Zabbix and Service now.

Confidential

System Engineer

Responsibilities:

• Diagnosis of production issues by monitoring error rates, application traffic, CPU utilizations, and log files. FTP, SSH, SCP Protocols (vsftpd, proftpd, openssh, rsync, netcat)
• As a 3rd level engineer, primarily handle 2nd level engineer support for the company's flagship product.
• Part of On call rotation team for production and non-production applications, servers and databases.
• Deploying experience with Jboss/WebLogic, Fusion Middleware, Splunk admin, apache application on production, customer test and staging environment.
• Maintaining the Environments like Dev, Sit, Uat, Pre-Prod and Prod.Created Jenkins Workflows for pre deployment process (DB execution, Environment configuration changes etc.) on both QA and preproduction Environments. Coordinated with all the teams before and after the production deployments for the smooth production releases.
• Written Shell scripts to apply the Integration label to all the files which needs manual labeling of files.
• Creating/Upgrading/troubleshooting Shell Scripts to automate the server processes and troubleshooting Python, Perl scripts and updating the scripts per approval from management on production/non-prod.
• Experience in deploying Java/WebLogic applications across multiple environments. Part of team for doing disaster recovery.
• Identify opportunities for improvement and take proactive steps to minimize production outages and delays. Work closely with development and QA terms to implement changes through the entire work cycle.
• Provide application support and technical assistance for internal and external customers (PROM, BIRCH, CROSS, Web methods, Accurint, WinESP, Apache server, WebLogic, BIS Online - Business Assurance).
• Install/deploy program products and system components or aid in installation by end users.
• Utilizes online system to assist with tasks encountered in execution of daily responsibilities such as utility functions and editing of files.
• Writes complex SQL queries to aid troubleshooting, find and fix data issues, and to support other customer requests used to analyze data and create management reports (SQL Navigator, PLSQL Developer, TOAD for Oracle, Sybase and SQL Yog for SqlServer)
• Create and update technical/procedural documentation. Responsible for maintaining and backing up internal production support website.
• WRQ Reflection for UNIX, HP Service Desk, PHP MyAdmin, MySQL, Norton Ghost, Web methods process management suite, HP Quality Center, ISIT ticketing system.

Confidential

Staff, System Admin

Responsibilities:

• Administer production Linux/Solaris/Window server and familiar with Netcool, Control-M, dashboard, Sitescope, Nagios, Splunk and various other tools.
• Network security/monitoring tools (iptables firewall, tcpdump, Nagios/Uptime/OpenNMS monitoring, nessus vulnerability scanning, nmap host discovery, Ossec HIDS, denyhosts)
• Handling the nightly batch jobs. Provides technical assistance to, DBAs, Network Engineers, Application Developers, Project Managers, Change Managers and QA.
• Automate the processes through Shell scripting, perl, python and troubleshooting prod issues.
• Web Servers software - Apache, Tomcat, Lighttpd server setup and administration
• Monitoring and optimizing the performance of the servers, manages of OS, system hardware and application performance and batch processing.
• Performed software configuration/release management activities for three different Java applications.
• Designed and implemented Continuous Integration process using tools like Hudson with approval from development and other affected teams. Defined processes to build and deliver software baselines for internal as well as external customers.

Confidential

System Analyst

Responsibilities:

• Assisted in (Linux) Centos running Asterisk PBX VOIP system, Open fire, SugarCrm, OrangeHrm and Window Servers 2008 (Active Directory), Group Policy and LDAP, Window Server 2008 hosting server, Plesk, Symantec Endpoint Protection Antivirus Server, Backup Execution Software, Cat-5 cabling, CCTV camera installation, MAC machine support, Build Sql server on window server 2008.
• Build backup server for VOIP Asterisk freepbx server.
• LAMP (Linux, Apache, MySQL, PHP) setup, configuration & maintenance. Shell Scripting to automate the process.
• Involved in migration from on-premises to Azure Cloud and created customer images for VM's. Installed, configured, managed windows servers, domain controllers, DHCP servers, DNS servers, created user accounts, groups, group policies, deployed, upgraded software, managed applications, backup and restored data, checked event logs, assigned permissions, managed tasks for disks and volumes, files and folders management, managed servers remotely, Monitored server performance, security related events, managed network printer
• Installed, administered, managed multiple Active Directory Domains, performed audits of AD objects and user permissions, developed OUs, managed group policies, managed active directory replications, managed FSMO roles, provided AD infrastructure, administration, installation, optimization, problem isolation and resolution.
• Responsible as a technical resource to Solaris Enterprise server trouble shooting and Administration
• Co-ordination with Vendors for Hardware failures and other Hardware supports. Remote administration using Telnet, Ssh, ftp, rlogin, putty.Sharing of resources in heterogeneous platforms using SAMBA. Backups using Tar, Ufsdump, Ufsrestore and Snapshot

Confidential

Technical Support Representative

Responsibilities:

• Solving problem related to IBM/LENOVO hardware and software.
• Provided effective and consistent technical support over the phone.
• Researched technical solutions.
• Responsible for handling all persistent cases.
• Support to wireless and complex issues.

Confidential

Quality Analyst

Responsibilities:

• Excellent Knowledge and Hands on experience in Manual Testing.
• Expertise in Problem Solving and Tracking Bug Reports Using Bug tracking Tools (Bugzilla).
• Good at writing Test Scenarios and Test Cases.
• Determined testing requirements developed and reviewed scripts for positive and negative test scenarios, conducted baseline testing, and generated reports. Tested server and Web Portal.
• Analyzed application, system, and security errors. Escalated issues to developers and verified fixes. Identified, fixed, and scrupulously documented system bugs.
• Writing test cases, preparing test plans, executing test cases and providing results to the Supervisor.
• Finding and following up on defects and ensuring they are resolved in a timely manner.

Confidential

Oracle Database Trainee

Responsibilities:

• Analyzed business requirements.
• Successfully planned and created a primary and standby database.
• Documented database recovery instructions.
• Created software user manual.