Chakravarthy L

Chakravarthy Lekkala Mobile: - E-mail:- Professional Summary: Over 9+ years of IT experience in SQL Database Administration, System Analysis, Design, Development & Support of MS SQL Servers 2005/2008/2012/2014/2016 in Production, Reporting Services, Development environments & Replication and Cluster Server Environments. Experience in Installations, Configuration and Maintenance of MSSQL 2005/2008r2/2012/2014/2016. Worked as a team member to provide 24x5 on-call production database support. Created documentations for Installation of SQL server 2005/2008r2/2012/2014/2016 and configuration of High availability Solutions. Experience in ITIL process(Incident, change and problem management) using ServiceNow tool Experience on Datacenter move, SQL Server 2012 and Windows 2012 upgrade activities. Created maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics. Experience in Database Backup, Recovery with RTO and RPO. Expertise in planning and implementing MS SQL server security and database permissions. Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS Packages. Experience in Installing, Configuring and maintaining SQL Server Active/Active and Active/Passive clusters. Configured the Always-on high availability technique in SQL server 2012/2014/2016 environment Good experience with implementing DR solution, High Availability of database servers using Database mirroring and replications and Log Shipping. Experience in SQL server Migration from SQL server 2005 to 2008R2, 2008R2 to 2012, 2012 to 2014 and 2014 to 2016. Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users. Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities. Using Performance Monitor/Profiler/Extended Events to solve Dead Locks/Long running queries. Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks. Administered, maintained, developed and implemented policies and procedures for ensuring the security and Integrity of the company database. Monitoring the nearly 20 servers by accessing remotely and analyzing the databases size ranging from 1GB to 1TB. Experience in investigating and applying necessary SQL Server database patches and installing service packs. Good experience in writing stored procedures, triggers and functions. Experience configuring and maintenance of SQL Server Log shipping, Mirroring and Backup/Recovery and planning. Automatic scheduled backups and monitor those backups are being performed regularly. Core DBA for Oracle 11g and MySQL 5.5/5.6/5.7 Installation and configuration of Oracle server in windows server Export and Import database schema's Creating users, assigning necessary roles to connect the database & object level permission Fixing the oracle client and oracle server connectivity issues Installation and configuration of MySQL server in windows server Resolving MySQL and application connectivity issues Configuration of Mirroring for MySQL 5.x versions (Master to Slave) .Net Application Configuration and Deployment (IIS Administration) Internet information services (IIS) installation and configuration on Windows server 2008 to 2016 versions. Deployment of .Net applications on Internet information services (IIS) Fixing database connection issues of SQL server, Oracle client connections (TNS names resolution and Listener connectivity issues) Resolving Crystal reports run time environment issues Resolving 32 bit and 64 bit compatibility issues Installation of .Net frame work Installation & configuration of Oracle client to connect oracle server Installation of MySQL connector to connect .net application to MySQL Server Professional Experience: Working as an Sr. Software Engineer with Bartronics India Limited from May’12 to till date Working as an MS SQL developer/Oracle core DBA with Neofision Solutions for First American India from Sep’07 to Apr’12. Education Qualifications: M.B.A (Information Systems) from Sikkim Manipal University B.Sc (Computer Science) from Sri Krishnadevaraya University Technical Skill Set: Databases SQL Server 2005/2008/2012/2014/2016, Oracle 11G and MySQL 5.x Operating System Windows 2005/2008r2/2012/2016 and Windows 7/8/10 TIBCO Products TIBCO Administration, Spotfire and MFT Tools SSMS, SQL Developer – Oracle, Toad and MySQL Workbench, ServiceNow BI Tools SSRS, SSIS, SSAS and TIBCO Spotfire Project 1: World Vision International (WVI) Client: World vision International Database: SQL Server 2008 R2/2012/2014/2016 Role: Sr. SQL Server DBA Description: World Vision International (WVI) is an Evangelical Christian humanitarian aid, development, and advocacy organization. It uses software from TIBCO Software Inc. to enable their new systems strategy, which allows desktop or mobile applications to operate remotely and communicate with the production systems using an Enterprise Service Bus (ESB) based on TIBCO Enterprise Message Service (EMS) and TIBCO Business Works (BW).  The first two applications created for this are SingleSTEP across 54 countries (and expanding).The SingleSTEP application gathers Child and Reference (project, country, zone, etc.) information produced by field workers and support around the world and aggregates it into a central Child database.  Then the data is distributed back to all to field workers to use for continued operations. Responsibilities: Provided 24 x 5 Production support for the databases and application issues. Database design, development, implementation and maintenance of SQL Server Monitoring SQL server performance using SQL Profiler to find performance and dead locks. Prepared the technical documentation. Monitored and modified Performance using execution plans and Index tuning Automation of CLE Logs Archive and Purge monthly basis Performance tuning on long running T-SQL Queries in SQL server 2012/2014. Monitoring and resolving Space issues, Jobs, Blockings and SQL related Virtual tickets. Developed SQL scripts for maintaining administration tasks. Worked on SQL server Migration from SQL server 2008R2 to 2012, 2012 to 2016 Experienced in resolving deadlock and blocking issues for concurrent users using Extended Events, SQL Profiler. Tuned the SQL queries using SQL profiler and involved in tuning the database. Administrate the TIBCO MFT server like adding users in Command Center, monitoring Internet servers and file transfers. Work with Application teams, taking in requirements and architect a SQL Server to meet their application needs, then working with Server team to get either physical or Virtual server setup and SQL Server installed and configured Created SSIS packages for the extracting, transforming and loading the data from different systems into SQL Server 2008R2. Worked on SQL server Migration from SQL server 2005 to 2008R2 and 20082 to 2012 Deploy the SSIS packages and create jobs in SQL agent. Developed SQL scripts for maintaining administration tasks. Build and Configured the Stage/Test and Dev environment based on customer requirements. Worked on Cut-over activity on Prod and stage environments. Worked on stage and Dev environment refresh with Prod environment. Administrate the TIBCO Spotfire Server like adding the users and generating the reports as per the Customer requirement Developed TIBCO Spotfire reports as per customer requirement. Created Information Links By using Information Designer to pull the data from Oracle Database and SAS data sets required to create the reports. Project 2:Product Traceability System (PTS) Client: SGS Tekniks Database: SQL Server 2012 Role: Sr. SQL Server DBA Description: Product Traceability System (PTS) will provide a system that increases the overall efficiency of tracking various components used in manufacturing/assembling PCBs by barcoding, labeling, monitoring and tracing at each stage of manufacturing process. The PTS application should allow a user to update the components and PCB’s information at different stages by using hand held terminals and web and desktop interfaces. Responsibilities: Installing and Configuring the SQL Server 2012. Database design, development, implementation and maintenance. Creating the database, data base objects and setting up the database parameters. Monitoring SQL server performance using SQL Profiler to find performance and dead locks. Prepared the technical documentation. Solving the Bugs Reflected by the Testing team. Rebuilding the indexes at regular intervals for better performance. Monitored and modified Performance using execution plans and Index tuning. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency. Managing the users and assign the privileges to them. Scheduled an automatic full backup weekly and incremental backup daily. Working with customers on Application rollouts and server migrations. Rebuilding / monitoring the indexes at regular intervals for better performance. Worked on moving and restoring the database backups from Prod to Test/Dev/Stage environments for testing activities. Configured the SQL cluster and Always on in SQL server 2012 Implemented SQL standards in writing stored procedures, Triggers, Views and locking issues. Creation and scheduling of Maintenance plans (database and log backups and cleanups) Scheduled and applying monthly security patches on Production and Non-Production environments. Monitoring and resolving Space issues, Jobs, Blockings and SQL related Virtual tickets. Configured Transactional Replication, Merge Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues. Experienced in resolving deadlock and blocking issues for concurrent users. Tuned the SQL queries using SQL profiler and involved in tuning the database. Project 3:Automated Field Reporting (AFR) Client: Dubai Traffic Police Database: SQL Server 2008/2012 Role: Operational SQL Server DBA and Development Description: Automated Field Reporting (AFR) is a solution that meets the growing need of quick and accurate reporting in a mobile environment. The field Reporting System allows officers to write and electronically file police reports from their mobile devices. Once completed, officers can quickly share report details through wireless transmission to headquarters for approval & notification. This significantly reduces the need for officers to return to headquarters to perform reporting tasks and provides an overall time savings to public safety agencies. Responsibilities: Database Administration and database Programming. Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users. To analyze long running slow queries and tune the same to optimize application and system performance. Managing the users and assign the privileges to them. Deploying new code base release to UAT and Production Environments. Working with customers on Application rollouts and server migrations. Involved in Index Analysis and Performance Tuning. Worked on configuring SQL Server with minimum privileged access. Troubleshoot performance problems, fine-tuning of databases and index Analysis. Actively Participated in developing logical model and implementing requirements on SQL Server 2008/2012 Implemented complex conceptual database design into SQL Server 2008/2012 using various Constraint and Triggers. Implemented complex business requirement in backend using efficient stored procedure and flexible function and facilitated easy implementation to the Front end application. Developed various T-SQL stored procedures/functions for the Application Involved in SQL Database design and Database objects. Created Database Objects like Tables, Views, Triggers and indexes using SQL server 2008/2012. Creating the database and design the table by applying the constraints. Writing queries and performing DML, DDL operations, stored procedures Project 4:Financial Inclusion Client: Bank of Maharashtra Database: SQL Server 2008/MySQL 5.1 Role: Sr. SQL Developer Description: Financial Inclusion is a WEB application and used for the customer enrolments and transactions for banking domain. Through this system the Customer Service Provider (CSP) can create a new enrolment record for a new customer. It provides transactions to a particular division on a daily basis as a report in XML format. An auto generated acknowledgment would be sent to the CSP. It also generates consolidated enrollments and transactions of the various customers under a particular division and group. Responsibilities: Installing SQL Server with minimum access privileges service account to improve security. Installed and configured SQL Server 2008 Troubleshoot performance problems and fine-tuning of databases. Worked in designing databases and capacity planning. Rebuilding the indexes at regular intervals for better performance. Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented. Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs. Monitored and modified Performance using execution plans and Index tuning. Rebuilding the indexes at regular intervals for better performance. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency. Designed and created databases, tables, views, store procedures and triggers. Participate in implementation of new releases into production. Project 5: Database: Oracle 10g/11g/MS SQL Server 2005/2008 r2 Role: SQL Developer Description: Being a shared resource I worked with multiple clients and people from around the world which helped me to handle people of various countries easily. As my daily routine need to work on multiple things for various clients. Responsibilities: I am responsible for regular upgrade, backup/recovery, performance tuning and maintenance of MS SQL server/oracle database. Planned, Designed and implemented Data Transfer between various versions of Oracle Servers using Export/Import utilities. Resolved issues related to the backup/restore/recovery of the database. Used exp /imp to export and import from production database and testing database. Created users, tablespace, roles and assign the privileges to them Provided the daily statistics of tables and indexes usage accordingly. Involved in documenting the environments and processes. Installation of Oracle (10g, 11g)/ MS SQL server 2005 Creating the database, tables, tablespace, data objects, setting privileges, indexes, user logins, passwords (security) and Creation of users and roles. Refreshed schemas from one environment to another using exp/imp utility. Restored tables, schemas in test environments from export backups based on business requirements. Database design, development, implementation and maintenance of SQL Server 2005/2008 R2 Monitoring SQL server performance using SQL Profiler to find performance and dead locks. Prepared the technical documentation. Monitored and modified Performance using execution plans and Index tuning