Nirmala Chandran
Database Administrator
.
.
*******.***********@*****.***
.
.
CAREER OBJECTIVE
Results-oriented professional with overall 7+ years of technical experience in SQL Server environments in Database Administration for the backend processes such as backup and restoring the database, performance monitoring, processing, developing, and scheduling jobs both on production and development environments. Looking forward to leveraging my abilities to successfully fill the database administrator role.
POFESSIONAL EXPERIENCE
SUMMARY :
Have 7+ years IT experience as DBA – MSSQL
Experience in complete Software development Life cycle (SDLC); Requirement Analysis, Design, development, Implementation, Testing,Deployment and Maintenance of applications including waterfall, Agile Scrum methodologies.
Backup and Restore databases.
Monitoring and scheduling Jobs in SQL Agent.
Supporting SQL Server mirrored databases and clustered environments.
Develop and maintain database support documentation.
Experience in MS Visio and Balsamiq to describe the workflow and better understanding of the project in a diagrammatic representation.
Provide a warm hand to our offshore support team.
Experience with monitoring, tuning, and analyzing database performance.
Implement database change requests.
Expertise in SQL Server and an understanding of various database products
Strong understanding about cloud platform AWS and Azure.
support of SQL server Mirroring, Clustering and other methods of disaster recovery.
worked in support team for day-to-day change needs in database.
Importing and exporting reports generated to Excel, CSV formats for the financial reports during Month End process,
Extensive knowledge in creating stored procedures, views & triggers and optimized queries in MS SQL.
Involved in the Month End process – Monthly Financial closing of the business -Process of generating various financial reports as per the documents.
Managed Active Directory for the roles and rights of the active members.
DATABASE ADMINISTRATOR
Wiztechies Pvt., Ltd. June 2015 – October 2022
CLIENT : NSMG
The objective of this project is to create an application based on OLTP for the client organization. NSMG North Star Memorial Group representing the nation’s finest funeral cemetery, cremation and memorialization locations based out of Houston, Texas.
Roles and Responsibilities :
Strong hands-on experience in SQL Server 2005, 2008, 2008 R2, 2012 features.
Involved in complete life cycle of the project from the requirement gathering needed for the entire process till testing.
Worked in creation of Tables and objects needed for the application.
Strongly experienced in backup & restore of the database.
Thorough knowledge about the SDLC.
Supported the development team with necessary database backup and restore in both production and development environment.
Hands on experience in HMIS tool.
Involved in coding SQL stored procedures SQL for simple modules.
Involved in coding for unit testing and prepared documentation.
Worked in DBA team for the successful release and supported the application after release.
CLIENT : UST- GLOBALS
Goal of the project is to develop an application for a health care provider for handling patient data such as patient demographics and encounter data for Friday Health plan.
Worked in requirement gathering and involved in complete SDLC of the project including Analysis, Design, Implementation, Testing and Maintenance.
Worked in creating, updating and altering tables as needed in MS SQL.
Supported in coding with development team.
Working knowledge of SQL Server 2008 R2/2012 and gained a good knowledge about SSRS, SSIS
Scheduling and regular maintenance of Jobs using SQL Agents.
Created SQL objects like stored procedures, Triggers, Cursors, views and SQL Joins.
Experienced knowledge about Agile scrum methodology through this project.
Can perform ETL utility functions.
Assist developers with MS SQL Server issues and questions.
Administer and monitor 24/7 applications and systems, developing automated alerts to warn of failure.
Good understanding about the data visualization tools such as Tableau.
Middle School Computer Science Teacher, Chennai, India
LMOIS International School, June 2009-March 2015
6 years at LMOIS International School taught Computer science Subjects for classes 5 to 8 grade
Handled and modified the classroom interaction and teaching skills to meet the need of various kind of students
Worked as a part of cultural committees for annual day, Sports day and various cultural activities
Instrumental in improving the mental health of the students by conducting short relaxation technique and meditation to them.
Office Secretary
Sarnath Consultancy Services, January 2002-October 2003
Responsible for the Official correspondence for the organization.
Managed the End to End accounting process for the company.
Handling payroll processing – Advance payments
Providing Clients with appropriate blue prints, CAD drawings for their construction sites
Handling the outstanding payments from clients – by following them
In-charge of the company's overall work
EDUCATION
MASTER OF COMPUTER APPLICATION(MCA), IN COMPUTER SCIENCE, Chennai, INDIA
University of Madras, May 2004
Relevant Coursework
Database Management System
.
Software Engineering
.
Data Structure
.
Operating Systems
.
Information Security
.
Programming in Java
.
.
BACHELOR OF COMPUTER APPLICATION(BCA), IN COMPUTER SCIENCE, Chennai, INDIA
University of Madras, May 2001
Relevant Coursework
Fundamentals of Digital Computers
.
Programming in C, C++ and Java
.
.
HIGH SCHOOL DIPLOMA, Chennai, TAMIL NADU
Muruga Dhanoshkodi Girls Higher Secondary School, April 1998
Relevant Coursework
Computer Science
.
Integral And Differential Calculus
.
Physics
.
Chemistry
.
.
Awards & Honors
School First in 10th Grade Mathematics (Secured Marks- 100%)
.
.
Extracurricular Activities
Volley Ball
.
Singing
.
Karate
.
.
SKILLS
Microsoft SQL
.
Administering Databases
.
Customer Satisfaction
.
.
Writing Queries
.
Running Backups
.
Database Support
.
Data Imports
.
Active Participation
.
Educational Support
.
Oracle
.
LANGUAGES
English (Advanced)
.
Tamil (Advanced)
VOLUNTEER EXPERIENCE
FOOD PACKER, Ricahrdson, Dallas, Texas
Feed My Starving Children (FMSC), April 2019-Present
Volunteering my time in Feed My Starving Children (FMSC). Working in Food packing work, labelling and warehouse.
VOLUNTEER, Dallas, Texas
Vibha Nonprofit Organization, January 2019-Present
Donating my time to Vibha Nonprofit organization and helping raising funds for the higher studies for underprivileged students. Volunteering in fund raising by growing and donating plant saplings, Seasonal Diya painting & sales, Crocheting bath towels for homeless, Tutoring refugee students and other ongoing initiatives.
PRECEPTOR, Dallas, Texas
Heartfulness Meditation, February 2016-Present
2002 Started practicing Heartfulness meditation system and volunteered in many areas like kitchen, reception, ashram office and Media team worked as Subtitle editor. 2016 became a Preceptor and helping many new seekers to initiate their meditation by giving sitting as ongoing process.
Secretary / Treasurer, Chennai, India
Leo Club International, January 1999-August 2003
Complete ownership in driving many community projects for public welfare which includes fund raising for Kargil War, Bull's eye projects, Blood donations drive and many others initiatives. Won the Par-Excellent Secretary Award and Par-Excellent Treasurer Award for 2 consecutive years.