Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Sowmya Challagulla

New York,NY

Summary

  • Certified SQL Database Administrator with 5+ years of experience at Perfume Worldwide Inc., I enhanced database efficiency by developing an internal SQL query optimization tool, reducing query times by 15%. Expert in RDBMS, SSIS, and project management, I blend innovative problem-solving with solid technical skills in a multicultural team environment.
  • High-performing professional with extensive experience managing large-scale, complex databases. Skilled in SQL and database management systems. Strong understanding of database design and data modeling with excellent troubleshooting skills. Smart and committed to staying up-to-date with new technologies and advancements.
  • Extensively worked on installing, configuring, optimizing and managing different versions SQL Server 2005, 2008 R2, 2012, 2014, 2016 and 2017 updating with latest hot fixes and service packs as per CIS standards.
  • Proficiency and expertise in SQL Server Backup/Recovery, Disaster recovery planning and Security Management.
  • Expertise in implementation of security models, Database authentication modes, creation of logins, granting permissions and assigning roles to users on databases.
  • Expertise in reading and understanding execution plan and fixing the query to execute with low cost.
  • Expertise in Database Mirroring as Disaster Recovery Solution.
  • Experience in Creating Tables, Views, Triggers, Dynamic Stored Procedures, User Defined Functions and other Transact-SQL (DDL, DML) statements for various applications.
  • Worked with SSIS & SSRS for various BI requirements.
  • Proficiency and Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning
  • Expertise in designing Relational Database Model, implementation and testing as per business needs.
  • Intensive experience in Monitoring and Tuning SQL Server and Database performance using SQL Profiler, Index Tuning Wizard, Windows Performance Monitor.
  • Experience in creation of logins, users and configuring permissions and assigning roles to users. Good understanding of Normalization/De-Normalization, Normal Form and database design methodology. Experience in Database Backup and Disaster Recovery procedures like database mirroring.
  • Worked extensively in Clustered environment (Active/Passive) to further increase scalability and stability of business critical systems.
  • Development of automated notification when SQL Server Backups and schedule maintained Jobs.
  • Experience in optimizing the query by creating various clustered, non-clustered indexes and indexed views.
  • Excellent communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent interpersonal and team work skills.

Overview

9
9
years of professional experience
1
1
Certification

Work History

SQL Database Administrator

Perfume Worldwide Inc.
04.2023 - Current
  • Created Active Directory with Security group with Table level permissions.
  • Responsible for maintenance of all the SQL Server and Oracle servers.
  • Created maintenance plan for regular scheduled Transaction log backup, Full backup (Separately in remote server), Check database, Reorganize index, Rebuild Index, Update Statistics and Cleanup task.
  • Create databases and schedule backups (Transaction log backup, Differential backup and Full backup) with Recovery sessions (Simple or Full).
  • Created an internal secured Website linking to the database that includes updated information about all Target SQL Servers information.
  • Setup Alerts, Notifications, Jobs, Job steps with automated response solution schedules.
  • Frequently Monitor Connections, Locks and Database Performance using Performance Dashboard.
  • Reviewed and optimized SQL queries, stored procedures, functions, Indexes, views and Triggers.
  • Plan and modify SQL server Permissions in quarterly basis.
  • Created optimal technical solutions to user needs with in-depth system analysis.
  • Produced high-standard database solutions to meet stability, reliability and performance metrics.
  • Supported projects enabling delivery efficiencies and technical resolution.
  • Designed and implemented TSQL queries for reporting and complex solution development.
  • Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
  • Documented analysis results and provided performance improvement feedback.
  • Developed custom database objects, stored procedures and delivered application support.
  • Implemented system enhancements to design and develop solutions to address problem reports.
  • Followed standard practices for migrating changes to test and production environments.
  • Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
  • Created and updated database designs and data models.
  • Developed scripts and processes for data integration and maintenance.

SQL Database Administrator

Perfume Worldwide Inc.
01.2016 - 08.2019
  • Contributed to the development of an internal tool for SQL query optimization, which was adopted company-wide and reduced query times by an average of 15%.
  • Solid experience in database development and support. Database migration, SQL Server 2000 upgrade to SQL Server 2005 and SQL Server 2005 to SQL Server 2014 using database mirroring.
  • Database performance tuning, capacity planning, and troubleshooting.
  • Expertise in RDBMS, data warehouse architecture and modeling, ETL experience.
  • Thorough understanding and experience in data warehouse and data mart design, star schema, snowflake schema, normalization and demoralization concepts and principles.
  • Expertise in SSIS (Integration Service), SSAS (Analysis Service), SSRS (Reporting Service).
  • Hands on expertise on SQL Server Notification Service, Service Broker.
  • Excellent T-SQL and database programming skills.
  • Solid experience in software development life cycle.
  • Over 3 years work experience in international team and multi-cultural environment.
  • Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-Indexing.
  • Involved in cluster implementation.
  • Extensive experience in project management and execution involving multiple concurrent development projects with a proven successful track record.
  • Exceptional ability to gather and translate complex user requirements into practical, cost-effective software solutions.
  • Scheduled the full backup, differential, transaction log backup of Database.
  • Additionally designed and implemented a disaster recovery system. Involved in disaster recovery procedures and restoring the production database.
  • Creative and innovative thinker, bringing energy, enthusiasm and leadership to problem resolution.
  • Planned and modified the permission issues in the server.
  • Created stored procedures to handle complex business rules, history data and audit analysis.
  • Maintaining SQL Script for creation of Database Objects.
  • Documented changes made to the servers, including documentation of performance

Education

Master of Science - Computer Science

New York Institute of Technology
Old Westbury, NY
05-2016

Bachelor of Science - Computer Science

Jawaharlal Nehru Technological University
India
05-2014

Skills

Languages: Net, SQL, T-SQL

RDBMS: MS SQL Server 2019, 2017, 2016, 2014, 2012, 2008, 2005, 2000

Database Tools: SSMS, SSIS, SSRS, SSAS

Operating Systems: Windows 95/98/2000/2003/2008/XP, MS-DOS

Utility Tools: MS Office, MS Project

Certification

Azure Database Administrator Associate

Timeline

SQL Database Administrator

Perfume Worldwide Inc.
04.2023 - Current

SQL Database Administrator

Perfume Worldwide Inc.
01.2016 - 08.2019

Master of Science - Computer Science

New York Institute of Technology

Bachelor of Science - Computer Science

Jawaharlal Nehru Technological University
Sowmya Challagulla