Software Developer

Summary Overall *.* years of software development, maintenance & support experience with more than 6.5 years of hands on experience as a programmer using multiple languages (PL/SQL, T-SQL, Shell

Scripting, JAVA, C# etc.). More than 4 years of experience in database administration activities like creating/maintaining logical & physical structures (i.e. databases, tablespaces, schemas, table, indexes, DB links, synonyms, types etc.), maintaining user access & profiles, monitoring data growth, database backup/recovery and capacity planning. Specialize in PL/SQL programming and query optimization. Highly proficient in database design, implementation and administration for Relational and NoSQL databases. Thorough understanding of Oracle, Postgres, Microsoft SQL Server, Impala, Hive databases. Beginner level understanding of Hbase and Cassandra databases. Developed ETL and customized Reporting jobs using Shell Scripting, SSIS, and SSRS. Possess additional skills about deployment of web applications in Jboss & WebSphere Application Server. Well aware of the Agile Development Methodologies and Source control software (i.e. GIT, STASH etc.)

Passionate about troubleshooting and problem solving. Ability to deliver results with no supervision. Quick learner, team player and self-organized professional willing to go the extra mile.

Education B.E Electronics & Communication, 2008 Dharmsinh Desai University Gujarat, India

Technical Languages:

Expertise PL/SQL, T-SQL, Impala SQL, HiveQL, CQL (Cassandra Query Language), Shell Scripting,

JAVA, C, C#, XML

Databases:

Oracle 11G R2/10G, Postgres 9.3, Microsoft SQLServer2005, Impala, Hive, Hbase, Cassandra

Developer Tools:

Oracle PL/SQL Developer, PGADMIN, Toad Data Modeler, Microsoft SQLServer Management Studio, SSIS, SSRS, SSAS, SQL*Plus, PSQL, Hive-Shell, Impala-Shell, CQLSH, WinScp, Putty, Clear Case, OOZIE, HUE, CDH, GIT, STASH, JIRA, Microsoft Visual Studio

Application Servers

Jboss 5, Web Sphere Application Server (WAS) 8.5 and WAS 6.1

SDLC:

Analysis, Design, Development, Testing, Deployment, Maintenance and Support

Domain:

QSR (Quick Service Restaurants), Insurance & Telecommunication

Experience Oct 2014 - Present Nexgen Wireless INC / PCTEL INC. Schaumburg, IL Database Developer/DBA

Provided database design, development & administration for Mobile Meridian & Seahawk Analytics applications.

Performed data modeling for RDBMS and NoSQL databases and established standards across modules.

Created customized modules for automated application data processing.

Developed big data loading processes using Hive and/or Impala.

Recommended database performance improvements after checking database performance reports.

Reviewed PL/SQL code and offered performance related improvements with the team as needed.

Maintained production, test and development databases.

Investigated and implemented third-party reporting solutions with an overall strategy for their integration.

Developed JAVA API’s for providing data access to application layer.

Environment

Languages : PL/SQL, Impala SQL, HiveQL, Shell Scripting, JAVA

Databases : Postgres 9.3, Impala, Hive

Tools : PGADMIN, Toad Data Modeler, PSQL, Hive Shell, Impala-Shell, WinScp, Putty, OOZIE, HUE, CDH

Sep 2008 - Oct 2014 IGATE Technologies/Patni Americas Oak Brook, IL

Project Lead (04/1/2014 – 10/03/2014),

Technical Lead (04/01/2013 – 03/31/2014),

Senior Software Engineer (04/01/2011 – 03/31/2013)

Software Engineer (09/26/2008 – 03/31/2011)

Trainee (12/10/2007 – 04/30/2008)

May 2010 - Sep 2014 Project: RFM Development, Deployment & Support

Created data model using Toad Data Modeler based on business requirements.

Developed required PL/SQL modules and created database logical and physical objects according to data model.

Utilized PL/SQL for providing required data in report format to business analysts.

Performed SQL tuning using standard techniques (i.e. execution plans, session trace, hints)

Reviewed SQL code developed by the offshore team and provided recommendations.

Worked with Senior DBA for infrastructure planning and future data growth.

Collaborated with Infrastructure team (i.e. server administration, virtual infrastructure, storage etc.) for procurement of infrastructure based on requirements.

Worked with application & infrastructure team for migration of infrastructure from one data center to another data center.

Deployed applications on Performance, QA, Staging and Production Environment.

Coordinated and performed application performance certification testing.

Conducted meetings for daily status and task distribution among offshore team.

Performed day-to-day database administration tasks and evaluated database performance reports on regular basis.

Developed ETL jobs and customized reports using Shell Scripting + Oracle, SSIS, SSRS.

Environment

Languages : PL/SQL, T-SQL, Shell Scripting

Databases : Oracle 10G & 11Gr2, Microsoft SQL Server 2005

Tools : PLSQL Developer, SQL*PLUS, Microsoft SQL Server Management Studio WinScp,

Putty, Oracle Enterprise Manager, Toad Data Modeler

App Server : JBOSS 4.3/5.0/6.1, WebSphere Application Server 6

Aug 2013 - Sep 2014 Project: Historical Data Purge

Analyzed data growth in database tables and validated usage frequency of the tables in core functional queries.

Defined group wise purging criteria for tables.

Coordinated with business analyst to get approvals about retention period of the data.

Developed scripts for purging data & tested scripts in test and performance environment.

Collaborated with market users and implemented purge scripts in Production databases.

Performed maintenance tasks (i.e. Rebuild/Reorganize indexes; analyze/compute stats if required after deleting the required data).

Environment

Languages : PL/SQL, T-SQL, Shell Scripting

Databases : Oracle 10G & 11Gr2, Microsoft SQL Server 2005

Tools : PLSQL Developer, SQL*PLUS Microsoft SQL Server Management Studio, WinScp,

Putty

Oct 2013 - Nov 2013 Project: Database Backup & Restoration Automation

Analyzed current backup and restoration process and created document for required changes as per database standards.

Modified current process for RMAN backup from control file to recovery catalog. The timings of the incremental and full backups were changes as per the business off hours.

Created automated process for RMAN backups.

Developed automated process for backup & restoration of specific tables & schemas using EXPDP/IMPDP and transitioned usage of this automated process to support engineers for future purpose.

Assisted support engineers in restoration of tables and schemas from full RMAN backups.

Environment

Languages : PL/SQL, Shell Scripting

Databases : Oracle 10G & 11Gr2

Tools : SQL*PLUS, PLSQL Developer, WinScp, Putty

Utilities : RMAN, EXPDP, IMPDP

June 2013 - Sep 2014 Project 4: Infrastructure Cost Reduction

Analyzed hardware installed and used in multiple environments (i.e. CPU & Memory usage, SAN usage, Licensing cost, maintenance cost etc.)

Recycle unused/unwanted objects (i.e. tables, tablespaces, users, files etc.) in the application and database servers.

Identified and removed fragmentation in database objects.

Checked current usage on multiple Oracle databases and resized tablespaces & ASM disk groups based on estimates for future growth.

Changed non-production databases to Non Archive Mode and then reduced SAN allocated for FRA disk groups.

Worked with business teams, identified retention period for data, then created, & implemented purging using PL/SQL & Shell scripting.

Worked with infrastructure team for resizing of different NFS mount points to release some unused SAN from application servers.

Decommissioned multiple unused servers and reshuffled applications to achieve server utilization up to 80%.

Worked with Infrastructure team for migration of the servers from physical bare metal solution to virtual environment in Cloud. (i.e. Virtual machines - Cloud)

Environment

Languages : PL/SQL, Shell Scripting

Databases : Oracle 10G & 11Gr2

Tools : PLSQL Developer, SQL*PLUS, WinScp, Putty

January 2009 - April 2010 Project: Domain Mid-Tier

Owning and resolving tickets related to PL/SQL code issues for business components. Provide support in 24*7 shifts.

Maintain and enhance PLSQL procedures and packages.

Identify issues, create a fix and deploy the fix in Non Production and then in Production environment.

Perform day to day database maintenance activities like (i.e. adding space to tablespace, export/import of databases, provide user access, weekly DB restarts, DB parameter changes, create/alter/drop objects etc.)

Work with application developers and design the relational databases in an effective way.

Conducted meeting for daily status and task distribution among offshore team.

Environment

Languages : PL/SQL, T-SQL, Shell Scripting

Databases : Oracle 10G & 11Gr2, Microsoft SQL Server 2005

Tools : PLSQL Developer, Microsoft SQL Server Management Studio WinScp, Putty

Contact this candidate