A qualified Technocrat and a seasoned professional with an extensive & successful career record in leadership, project management and team management skills offering 14 years of experience in Database Application Development in Client Server and Web based Technology. Proven track record of effectively delivering complex technical projects to meet customer requirements, providing technical support and specific proficiency in business process re-engineering. Currently associated with Maxworth Innovations, Chennai as Principal Consultant DBA. RAJESH KANNA .C

AF4- Kamlam Flats, School Road, Kolathur, Chennai – 600099 Email: adp2ls@r.postjobfree.com Phone: (M) +91-989******* IT INFRASTRUCTURE MANAGEMENT

Seeking challenging assignments to leverage experience and expertise with an organization of repute CAREER SUMMARY

Technically-sophisticated and business-savvy management professional with a pioneering career reflecting strong leadership qualities coupled with enormous experience & exposure in Administration, designing and implementing successful cost-effective, high-performance IT solutions Thorough understanding of entire Project Life Cycles Demonstrated success in streamlining existing operations. Comprehensive experience in project planning, budgeting, and implementing effective cost controls Adept in IT Server Infrastructure Management, Network Set up and Management, Database Administration

(including Server Implementation & Administration), Technology Support and Technical Troubleshooting with experience of establishing vendor networks & partnerships Implemented best practices in different projects for smooth delivery as per customer requirements Possesses very strong organizational, management, communication and inter personal relationship skills Systematic and analytical with proven leadership abilities laying emphasis on creating `Cohesive Teams' for delivering outstanding results

Project Management

IT Server Infrastructure

Database Administration

Technology Leadership

COMPETENCY MATRIX

Business Solutions

Quality Assurance

Client Relationship Management

Troubleshooting Ability

TECHNICAL PROFICIENCY

Operating Systems: Windows 2019

Database: SQL 2008, 2012, 2016 and 2019

DB Monitoring Tools: Spot Light, Red Gate and SQL Beat Documentation Tools: Ms Visio – 2016, Ms Project – 2016 AREAS OF EXPERTISE

As Core SQL Production DBA

10+ years of experience in Database Administration for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2016 and 2019.

Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting

Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.

Expertise in T-SQL writing stored procedures, triggers and functions.

Administering SQL Server High Availability and Disaster Recovery strategies.

Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.

Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.

Worked on logical and physical data base modeling with UML and ERWIN tools.

Experience in using DMV and dynamic management functions for finding out long running queries.

Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.

Experience in Disaster Recovery Planning and Security Management operations.

Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.

Having hands on experience in DR processes including Log Shipping and Database Mirroring.

Worked on configuring SQL Server with minimum privileged access.

Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.

Troubleshoot performance problems, fine-tuning of databases and index Analysis.

Worked on SQL Server 2012 migration from SQL Server 2008 / 2005.

Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.

Implemented Always-ON (AAG) on SQL Server 2012 SP2 CU5

Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.

Having Experience on Data center servers and handling 1.4 TB databases.

Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.

Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.

Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.

Working knowledge in Analysis Services(SSAS), Reporting Services(SSRS) and Clustering.

Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.

Strong experience in mentoring team members and writing documentation. 24 X 7 Production Database on Call Support

Estimated disk storage requirements for database software, database files & database administration needs Efficiently handled database more than 1 TB Size

Scanned the data pages, Indexes and checked the storage space used by each table Hands on experience in AZURE SQL Database, Azure storage and virtual machines Database Refreshes

As an Application DBA Support

Involved in performance tuning, code optimization

Performed all the Database related activities such as Database Backup, Restore Operations, Troubleshooting Issues as and when occurs, Performance Tuning, monitoring error logs, jobs etc. Designed, implemented & maintained DTS Packages

PROFESSIONAL EXPERIENCE

Max Worth Innovations. Chennai (Jan 2018 – Till Working) Database Consultant

Voice gear networks PVT LTD, Chennai (Dec- 11- Dec-17) Principal Consultant (Reporting to Manager Consultant) KNOWLEDGE UNIVERSE TECHNOLOGIES INDIA PVT LTD, Chennai (Feb’08 – Nov’11) Senior Database Administrator (Reporting to IT Infrastructure Manager) M/S. AALPS INFO PVT LTD, Chennai (Aug’07 – Feb’08) Database Administrator (Reporting to Senior Database Administrator) M/S. TORA INTERACTIVE SOLUTIONS PVT LTD, Chennai (Aug’03 – Aug’07) Database Administrator (Reporting to Senior Database Administrator) M/S. JAGAMPACK INFO –T- SYSTEMS PVT LTD, Chennai (Sept’01 – May’03) Junior Database Admin (Reporting to Senior Database Administrator) M/S. HINDUSTAN SOFTWARE LTD, Chennai (May’98 – Jun’01) Team Leader

PROJECTS EXECUTED

Project#1: HOUSE KEEPING WEB BASED ERP

Client: Sinar Jernih Sdn Bhd

Software: MS Sql Server 2019

Description: Sinar Jernih Pvt., Ltd., is a company that does house keeping for Five Star Group of Hotels, MNC, and Other Big Hospitals. Currently Sinar manually maintains its daily activities. To automate it, developed Software for maintaining the whole activities. This software is going to act like one stop shop for Sinar. The software divided into modules like HR, Operations, Logistics, Finance, Quality and Admin. Responsibilities:

Prepared operating system backup and logical backup Schedule (import-export: full, cumulative and incremental modes) for clients

Instrumental in tuning database for performance enhancement by using indexes Database design Created database, datafiles, tablespaces, users, tables, indexes, roles, database triggers and procedures Responsible for Multiplexing control files and redolog files Distributed database environment and created database links and snapshots for replication and distributed transactions

Accountable for Space Management, reorganization of data and security aspects for user privileges through grant and revoke authority

Project#2: Horizon Product Release

Client: Champions

Software: MS Sql Server 2012

Description: Horizon is a web based application it deals with online activities of Child care centers in USA. With interface of parent portal. Its contains many modules. Online Account Management, Field Management System and Time and Attendance Tracking. Responsibilities:

Prepared operating system backup and logical backup Schedule (import-export: full, cumulative and incremental modes) for clients

Instrumental in tuning database for performance enhancement by using indexes Database design Created database, users, tables, indexes, roles, database triggers and procedures Distributed database environment and created database links and snapshots for replication and distributed transactions

Applying DB Scripts into Production Environment

Project#3: PEARL & JEWELRY EXPLORER

Client: Sonata Group of companies, Singapore

Software: MS Sql Server 2012

Description: Pearl & Jewelry Explorer is multi lingual, multi currency and multi user Inventory and Accounting Software, dealing with multiple products such as Jewelry, Pearls, Pearl Jewelry, and Stone & Branded Jewelry for Sonata group of companies, the world's first and the largest manufacturing and selling industry in the above areas. All aspects of Inventory and Accounting such as Consignment In, Purchase, Consignment Out, Carry Out, Sales, Production, Manufacturing, Mixing, Stock Transfer, Payment, Receipts etc., are included. Responsibilities:

Involved in the design of the database structure, table design, creation of database, datafiles, tablespaces, users, rollback segments, tables, indexes, roles, database triggers and procedures Managed data storage and users plus weekly offline backup of data Created indexes for query performance enhancement

Project#4: NETWORK MANAGEMENT OF DATABASES

Client: Sonata Group of companies, Singapore

Software: MS SQL Server 2008

Description: The Card Management System deals with the centralized management of database across different branches of the organization interact with the centrally located database which records information about Customers information, Credit, Debit Card Transaction Details, Executive information.

Responsibilities:

Configured and installed MSSQL server, tools, and utilities in a very large distributed database environment Provided on going installation and support of all MS SQL software upgrades Installed and configured IIS web server

Created repository for MS SQL Enterprise manager and other SQL tools Created various databases with appropriate parameters for the best performance Created database objects (tables, views, indexes, stored procedure, and packages) Created links and synonyms for distributed database access, snapshot for replicated database access Created triggers, rules, defaults, constraints for maintaining business rule, entity integrity and referential integrity

Documented each DBA activity involved with data modelling of the system using E-R Diagrams Project#5: UNIVERSAL FOREIGN SECURITIES MANAGEMENT SYSTEMS Client: Nikko Solutions, Japan

Software: MS SQL Server 2005

Description: Universal Foreign Securities Management System (UFSMS) is a system which manages the configurations of the securities that are traded in Overseas Markets. UFSMS system provides facility to place, cancel orders for Bonds, Stocks and Mutual Funds. Responsibilities:

Created proper table space and rollback segments

Monitored growth of database size and altering as required Calculated correct storage parameters for tables, indexes and rollback segments by monitoring the growth characteristics of the objects

Responsible for database tuning, performance tuning, application tuning, memory buffer management, lock management during transaction, query optimization using different tools Took regular backups in Archive Log environment to recover the complete data in case of media, database, network failure

Created roles and profiles then assigned them to different users Created/removed database users

Promptly resolved problems during live production

Project#6: HOSPITAL MANAGEMENT SYSTEMS

Client: St. Vincent Hospitals - Brazil

Software: MS SQL Server 2000 with Visual Basic

Description: This project aims to computerize in total Hospital Management Systems. This Software consists of Patient Admission Module, Patient Discharge Module, Patients Bed Transfer Module, and Patient Room Allotments. Patient Operation Theatre Schedule Module, Billing and Pharmacy Modules, Patients Lab Details Modules are available. It will generate automatically Code Number for all Patients.

Responsibilities:

As an SQL Server Database Administrator, responsible for database administration during extensive testing of the software at the development site, design and some development work Implemented database design, installed and configured the SQL database EDUCATIONAL CREDENTIALS

MCA from Madurai Kamaraj University in 2011

BCA from Madurai Kamaraj University in 2002

Diploma in Impact Course (Oracle, MS SQL Server) from Software Solution Integrated Ltd, Chennai Diploma in Hardware Engineering from M/s. Cadcae Computers - Dindigul Diploma in Computer Technology from R.V.S. Polytechnic in 1995 PERSONAL VITAE

Date of Birth: 15th April, 1973

Languages Known: English and Tamil

Location Preference: Chennai

Permanent Address: #1/8a, Ellaya Allwar, 2nd Street, Taluck Office Road, Dindigul – 624 001 Passport Number: H5543173 Valid Up to 01-April-2029 References: Available upon request

Contact this candidate