Summary
Overview
Work History
Education
Skills
Certification
Volunteer Experience
Training
Timeline
Generic

Swarna Latha Nemalapuri

Malden,MA

Summary

Experienced SQL DBA proficient in managing production servers across SQL Server 2012, 2008R2, and 2008 environments, including installation, migration, and configuration tasks for clustered and standalone server environments. Skilled in replication techniques such as Snapshot and Transactional, with expertise in planning and executing upgrades including service packs. Proficient in database administration activities including health checks, index optimization, performance tuning, and query optimization, with a focus on database security and troubleshooting. Additionally, demonstrated capabilities in mentoring teams, coordinating with developers, and effective communication, complemented by freelancing experience as a Manual Test Analyst involved in all phases of the Software Testing Life Cycle (STLC).

Overview

12
12
years of professional experience
1
1
Certification

Work History

NAEP Administrator

Westat
12.2021 - 04.2024
  • Assisted in the creation of accessible testing accommodations for students requiring specialized support or modifications due to disabilities or other challenges.
  • Maximized accuracy by conducting regular quality assurance checks on administered assessments and scoring procedures.
  • Streamlined data management for better organization, resulting in faster report generation and analysis.
  • Served as a resource for staff, providing guidance on best practices in assessment administration and offering support as needed during the testing process.

Administration Monitoring

Harvard
01.2020 - 04.2020
  • Supported administrative tasks such as filing, data entry, and document preparation for more efficient office workflow.
  • Ensured accurate record-keeping with diligent data entry and database management for vital company information.
  • Created and maintained databases to track and record customer data.

SQL Server DBA

American Students Association
04.2013 - 08.2013
  • Installed SQL server 2012 on windows 2012 standalone servers and migrated databases from SQL server 2008R2 to 2012
  • Installed and configured SQL severs on Virtual Machines also managed the SQL server which is in VM by V Sphere client tool like taking snapshot of the server before any changes and additional disk space and monitoring VM alerts
  • Responsible for monitoring and making recommendations for performance improvement in hosted databases
  • Designed and deployed SSIS packages through command prompt for data loading for various applications in AMSA Worked on SSRS drill down reports deployed them on report server from report manager
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support
  • Used SQL Diagnostic Manager for monitoring SQL server for low disk space, SQL server logs and any CPU, memory and IO issues also gathered information about database growth by month wise
  • Involved in Mask database backups and Restores from upper region (Production) to lower regions Test and Dev and apply scrubbing scripts to sync the logins for AMSA
  • Involved and deployed various production releases for all the applications in AMSA and trouble shoot the problems after the release.

Fresher

NTTDATA Inc
01.2012 - 10.2012
    • SQL database administration, involved in backups, restores, creating databases, scheduling jobs and SQL server installations
    • Executed production deployment and other various production releases
    • Worked as assistance for HR department.

Education

Certificate in Data Management -

Bunker Hill Community College
Charlestown, MA
05.2017

Master's in Public Personal Management -

Osmania University
India
04.1999

Bachelors' of Science Botany, Zoology, Chemistry -

Osmania University
India
11.1995

Skills

  • Project Domain: Administration of MS SQL Server 2008R2/2008
  • Tools : DTS, SQL Safe, Lite Speed, Spotlight, SQL Profiler, Idera, and Red Gate
  • Operating Systems: Windows NT/XP/2008/2008R2
  • Languages: SQL, TSQL
  • Databases: SQL Server 2008R2/2008
  • Markup Languages: HTML, XML
  • ETL Tools: DTS, PL/SQL, TSQL
  • Administrative Support
  • MS Office
  • Customer Service
  • Recordkeeping and File Management
  • Work Planning and Prioritization; Scheduling

Certification

Microsoft Certified Technology Specialist, SQL Server 2008, Implementation and Maintenance

Volunteer Experience

  • Sesha Sai enterprise (Electronics), Front Desk Customer Support, 01/2004, 12/2006
  • Bread of Life Volunteering 2019, Present

Training

QA, SQL Server certification from MCTS

Timeline

NAEP Administrator

Westat
12.2021 - 04.2024

Administration Monitoring

Harvard
01.2020 - 04.2020

SQL Server DBA

American Students Association
04.2013 - 08.2013

Fresher

NTTDATA Inc
01.2012 - 10.2012

Certificate in Data Management -

Bunker Hill Community College

Master's in Public Personal Management -

Osmania University

Bachelors' of Science Botany, Zoology, Chemistry -

Osmania University

Similar Profiles

CREATE PROFILE
Swarna Latha Nemalapuri