SUMMARY

• Over 5 years’ experience in IT industry as programmer analyst using Python, SQL, PL/SQL and Cognos to design, develop and enhance system operation metric.
• Worked on AWS services such as (EC2, EBS, ASG, RDS, R53)
• Developed AWS Cloud Formation templates to create custom sized VPC, subnets, EC2 instances, ELB, Security Groups.
• Created a high availability and scalable AWS stacks using EC2 auto scaling functionality.
• Worked on EBS, storage service S3 (buckets creation, folder navigation and property changes) and and data migration activities. Have knowledge on glacier services.
• Experience in developing advanced Databases like Oracle, MS - Access, SQL Server.
• Good knowledge of DNS, firewall and intrusion provision systems
• Expertise in triaging issues on SSL handshake and in depth understanding of different SSL protocols and cipher suites.
• Experience in leading critical deliveries and ensuring that they GO-LIVE as per planned schedule.
• Experience in analyses, troubleshooting and problem solving skills.
• Expertise in unit testing and ETL process.
• Excellent coding skills in writing stored procedures and triggers and automate the script in the SQL server.
• Involved and Configured Oracle 11g database instance running across two oracle RAC nodes on Red Hat Linux AS 4 Server
• Installation, maintenance and tuning of RAC Applications. Performed Table, Index Partitions for increased performance and for better storage management.
• Monitoring and performance enhancement using session Tracing, Statspack and CPU utilization.
• Identifying bottlenecks and wait based analysis using Oracle Wait Interface.
• Documented the Role Transition method from Primary to Standby and vice versa of Data guard environment.
• Performed database Migration from Windows platform to Linux using RMAN (Convert) and Data pump.
• Analyzing the Automatic Database Diagnostic Monitor Reports from various Databases in various time intervals, creating BASELINE and monitoring performance metrics of Databases WORKLOAD.
• Translating technical and Business requirements into efficient Logical and Physical data models.
• Performing Database Refreshes using Exp/Imp, Datapump, Sql*Loader, EMC Clone, RMAN.
• Created Reports and dashboards for the users to monitor and track their regular activities.
• Organizing triage calls between Sirius XM, Sustain and Development, and Operation teams on priority issues and resolving them.
• Excellent Business writing skills in writing Business requirements document BRD, Use Case Specifications, Functional Requirement Specifications FRS, Software Design Specification SDS, Software Requirements Specification (SRS), Software External Specifications SES, Software Requirement Document (SRD), Data Dictionary, Business Continuity Plan (BCP), Workflows and Unified Modeling Language (UML) diagrams such as Activity diagrams, Class diagrams and Sequence diagrams.
• Good working experience as a programmer analyst and involved in various phases of entire project from requirement gathering, software development, and Implementation.
• Takes initiative and possesses excellent communication skills both written and verbal.

TECHNICAL SKILLS

Programming skills: Java, Python, C, R, hive

Databases: Oracle 12C, SQL SERVER (13.0.1601.5 ), MS-Access (16.0.4229.1024 )

Tools: Minitab, SPSS, EPIC, Cognos, Tableau, MS Active Directory, MS Exchange

Process Management: Sigma Flow Process.

Web Technologies: HTML, HTML5, XML, Web design, JavaScript

PROFESSIONAL EXPERIENCE

Devops Engineer/Programmer Analyst

Confidential

Responsibilities:

• Responsible for coordinating with Build and release team for creating software baselines, code merges, branch and label creation in Subversion/GIT.
• Maintaining a farm of EC2 instances, ELB's and RDS..
• ' Architected a virtual private cloud in AWS and automated the same using Ansible and python
• Worked on Cloud automation using AWS Cloud Formation templates.
• . Configured Jenkins in a Docker container with EC2 slaves in Amazon AWS cloud configuration.
• Responsible for creating new IAM users & groups in addition to defining roles and policies in the directory server.
• Responsible for hosting static content on AWS S3 and having them updated on content delivery network
• Implemented rapid-provisioning and life-cycle management for Ubuntu Linux using Amazon EC2, Ansible, and custom Python/Bash scripts
• Involved in configuring two node RAC on 11gR1, oracle cluster ware on Red hat Linux AS 5.
• Configured server/client side load balancing.
• Migrated single instance database to multiple instance database (RAC) using export/import, datapump.
• Upgraded few production databases from version ORACLE 10g to ORACLE 11g.
• Created Partitions and Sub Partitions on large tables for easier manageability
• Extensive UNIX Shell scripting in csh, ksh.
• Importing and exporting files, databases, schemas and tables using SQL* loader and utilities like Import, Export and Data Pump features of Oracle database 10g.
• Involved in designing and creating schema objects like Database tables, indexes, views, materialized views and synonyms
• Checking of Alert log and Trace files to monitor the database on a daily basis. Also wrote monitoring scripts to check reports for space, Max. Extents, coalescing etc kept in CRONJOB.
• UNIX shell scripting in csh, ksh to be controlled from Crontab.
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication.
• Tuning Oracle databases and tuning applications (SQL), for tuning SQL working closely with development Team.
• Usage of Partitions to improve the query performance and manageability.
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN.
• Deciding the naming conventions of data file, redo log files, table spaces, and segments.
• Generation of the AWR (Automatic Workload Repository), ADDM, ASH Reports and using them for tuning the database.
• On call support 24/7
• Writing Audit Triggers and debugging Stored Procedures, Package’s, Functions-PL/SQL.
• Wrote Shell and Perl scripts for monitoring and automating tasks of various Databases.
• Enhancing performance using various components like SQL TUNING ADVISOR, ACCESS TUNING ADVISOR, SEGMENT ADVISOR, UNDO ADVISOR and Automatic Shared Memory Management.
• Resolve database performance issues, database capacity issues and other distributed data issues (OLTP).
• Creating Materialized views and Materialized View Logs for Increased Performance and Data Replication.
• Working with optimizer Hints and Explain Plan for estimating performance and to generate optimal solutions.
• Translating technical and Business requirements into efficient Logical and Physical data models.
• Configured and Installed ORACLE 10g, 11g software on Red Hat Linux 4 Servers.
• Installed & configured Web logic server on UNIX platform and deployed applications.
• Created and monitored Physical standby databases on maximum protection, performance mode using Data guard for Disaster Recovery and performing production databases Maintenance.
• Configured Automatic Storage Management (ASM) for 10g RAC databases for reducing disk contention and providing centralized management for Disks.
• Supported installation and setup of ORACLE Cluster’s and RAC database.
• Monitoring and Administrating ORACLE RAC databases on ORACLE 11g Clusters.
• Interact with System operations leads, business users to develop requirements
• Design, development of PL/SQL stored procedures, functions, triggers
• Developing containment scripts for data reconciliation using SQL, Python and hive.
• Developing/enhancing system operations metrics web application using Java.
• Assist QA teams in setting up test data for system testing and performance testing activities
• Analyzing live customer escalation issues and providing solutions for Sirius XM radio service
• Assist Sirius XM users for installation and maintenance of Scorpio system.
• Develop use case, system requirements and design artifacts using GM software development process
• Generate daily, weekly, monthly and quarterly reports for leadership review using Cognos and Tableau tools
• Organizing triage calls between Sirius XM, Sustain, and Development and Operation teams on priority issues and resolving them.
• Send a Cancel/New for all the vehicles that are under wrong radio service and update these vehicles with correct service in SQL
• Provided SSD, Cruze 24/7 promise updated scripts to sustain team for 5.0,5.1 and 5.2 releases
• Updated the promotions in the Program Management Tool that tells what type of service should be given to certain vehicles depending on the RPO code.
• Receive METAL file from GEPICS team every week and run the ETL process to load the data in to XM tables.
• Working with GIF team to make sure FF POLAR ran every day at 12 AM and all the data is loaded in to factory feed tables.

Environment: Tomcat, Apache, Oracle 11g, AWS VPC, AWS ELB, AWS SQS, AWS S3, AWS Cloud Formation Templates, AWS RDS, AWS Cloud Watch, Jenkins, Python, EC2, Linux.