THARA LEELA

adm1zl@r.postjobfree.com

+1-971-***-****

Portland, Oregon, USA

Experience Summary

Have more than 9 years of programming experience as an MS SQL and Oracle PL/SQL as Developer.

Experience in SQL Server 2008/2012/2016 SQL, T-SQL, Stored Procedures, Functions and Triggers.

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing and maintenance with timely delivery against aggressive deadlines.

Expertise in Client-Server application development using SSMS, Oracle 11g/10g/9i/8i, SQL developer, SQL *PLUS and TOAD.

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using PL/SQL.

Experience in using recursive CTEs, CTE and temp tables to facilitate effective data manipulation and data consistency as well as to support the existing application.

Translated the T-SQL procedure, function and views into Oracle’s PL/SQL packages, procedure, Function and Views.

Worked extensively on Ref Cursor and Exception handling.

Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.

Proficient at working as a team player with an aim of contributing towards the team's success.

Involved in unit testing and have well knowledge about CI/CD process and documented the same.

Highly proficient in the use of T-SQL for developing complex creating Database, Tables, Indexes, Views, Triggers, Stored Procedure, User Defined Function, relational database models and data integrity, SQL joins and query writing.

Have basic knowledge on moving the data using SSIS.

Have basic knowledge on SSRS and power BI.

Good ability to quickly grasp and master new concepts and technologies.

Education

Bachelor of Technology (B.Tech) in Electronics and Instrumentation from Cochin university of Science and Technology, India in 2008.

Technical Skills

Database: MS SQL Server 2000/2005/2008R2/2012/2014/2016, MS SQL Server Integration Services (SSIS 2008R2), MS SQL Server Reporting Services 2008, Cognos, MySQL, postgreSQL, Oracle 9i/10g/11g-PL/SQL

Software Applications & Tools: Microsoft SQL Server Management Studio, Microsoft Visual Studio, SSDT, Oracle SQL Developer, Eclipse, TOAD, Putty, SQL Yog, pgAdmin, Sentry one, SQL profiler

Programming Languages: TSQL, SQL, PLSQL, MySQL, PostgreSQL

Operating Systems: WINDOWS, UNIX, Linux.

Professional Experience

Mar 2019 to Mar 2021 TATA Consultancy services

Client : CDK Global

Role: SQL Server Developer Portland, Oregon, USA

Worked as part of development team in creating new procedures and altering the existing ones.

Have done review for existing business procedures and recommended and implemented changes for performance tuning.

Have done research on Performance tuning in finding Missing Indexes and Unused indexes from the databases and finally implemented in production servers.

Designing, implementing and maintaining the database schema, entity relationship diagrams, tables, stored procedures, functions and triggers, constraints, indexes, functions, views, rules, defaults and complex SQL statements.

Have good knowledge about Fragmentation and table partitioning.

Creating complex stored procedures using a linked server, CTE, temp table, SQL joins, ranking functions and dynamic SQL and responsible for performing t-SQL tuning and optimizing queries which takes longer time in execution.

Familiar with the source controlling tool GIT

Creating and managing the clustered indexes and non-clustered indexes and optimized queries using execution plan.

Have dealt with OLTP and OLAP tables.

Completely aware of Agile process.

Database management including backups, restores, updating statistics and rebuilding indexes.

Environment: SQL Server 2016, GIT

Mar’17 to Mar’18 ARS Traffic and Transport Systems

Role: Senior Database Developer Kerala, India

Interacting with Onsite people, taking clarifications regarding applications.

Analyzing the requirements and discussed with managers and leads on the functionality.

Knowledgeable Entry Level SQL Server Database Administrator with a wide breadth of software installation and maintenance knowledge.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Create regular backup scripts and backup of databases, perform database recovery from the backups in case of database crash.

Worked under Agile Methodology throughout the project, performed decisive role in developing and planning as well as coordinating with assigned tasks.

Developed complex SQL Queries, Joins, Sub Queries, Stored Procedures, Functions, CTE’s, Views, Constraints, Cursors with best execution plan in SSMS to implement the business logic Participated in system analysis, which included creating tables, views, indexes, synonyms, triggers, functions, procedures and cursors.

Partitioned large Tables using range partition technique.

Involved in working with IMPLICIT CURSORS and EXPLICIT CURSORS.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Monitoring SQL server performance using SQL Profiler to find performance and dead locks.

Extensively worked on DBCC commands.

Export or Import data from other data sources like flat files using Import/Export through SSMS.

Optimizing and Performance Tuning SQL Scripts to make reports run smoothly and efficiently.

Environment: SQL Server 2005/2012/2016, T-SQL, SSRS, SSMS, SQL Developer (Oracle), SQL Yog, pgAdmin

Mar’09 to Dec’15 Infosys Limited

Role: Senior Developer. Kerala, India

Coordinated with the front-end design team and developed stored procedures and functions called from Finacle applications or UNIX shell scripts.

Interacting with client on daily basis for status reporting purposes.

Involved in enhancements projects and fixing production issues.

Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.

Developed materialized views for data replication in distributed environments.

Developed Complex SQL queries using various joins thorough out the projects.

Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.

Developed complex queries including Sub queries, Unions, Intersects and Aliases.

Wrote UNIX shell scripts to process files on daily basis like renaming the file, extracting data from the file, unzipping the file and remove the junk characters from the file before loading them to the base tables.

Wrote heavy stored procedures using Dynamic SQL to populate data into temp tables.

Provided estimates for Change Requests raised by the client.

Experience in working a variety of analytical functions like RANK, DENSE RANK, LAG, LEAD, and PARTITION OVER.

Created automated stored procedures for day end operations using SQL Server agent.

Monitor the SQL server Agent jobs and fix the jobs on failure.

Co-coordinating with QA team for testing in QA Environment to get sign off.

Create indexes on the table for the fast retrieval of the data to enhance database performance.

Worked on performance tuning of slow running queries.

Have worked on Jasper reports.

Environment: MS SQL Server 2008/2012, SQL Plus, Toad.

Contact this candidate