SQL SERVER DBA/DEVELOPER

Vinitha Reddy

vinitha.reddy27@gmail.com                                                                                  (678) 720-8939

PROFILE SUMMARY

Over THREE years of experience in IT industry, with a wide range of experience in Database Administration and Development using MS SQL Server 2008R2/2008/2005/2000 environments.

  • Experience in Installing, Upgrading, and Migrating SQL Server databases.
  • Experience in Extracting, Transforming and Loading data from various heterogeneous data sources like Access, Excel, CSV, Oracle, flat file, Text Format Data using OLE DB connection by creating various DTS & SSIS packages.
  • Excellent SQL Server Developer skills including writing Triggers, Stored Procedures, Views and functions.
  • Experience in managing OLAP Database Warehouses using Analysis Services (SSAS), Integration Services (SSIS), and Reporting Services (SSRS).
  • Excellent skills in database Back Up, Restore, Recovery, Updating statistics, Rebuilding and Reorganizing Indexes, Defragging Tables, Replication, Linked Servers, and Database Maintenance Plans.
  • Hands on experience with High Availability & Disaster Recovery Solutions – Log Shipping, Mirroring (High safety and High performance), Replication (Snapshot & Transactional) and Clustering (Active-Passive and Active - Active).
  • Experience in Query Optimization and Performance Tuning. Used Execution Plans, Performance Monitor, and DBCC Commands.
  • Expertise in using Performance Monitor, SQL Profiler, Activity Monitor to resolve deadlocks, Long Running Queries, and Bottlenecks caused by complex queries.
  • Hands on experience in Planning & Scheduling Maintenance Tasks, Scheduling Jobs, and Alerts using SQL Mail.
  • Experience in using third party tools like LiteSpeed, Red Gate and Automate.

TECHNICAL SKILLS

Databases:                  MS SQL Server 2008R2/2008/2005/2000, Oracle

Languages:                T-SQL, C, C++, C#, vb.net, JAVA, ASP.NET, Visual studio.                                  

Operating Systems:   Windows Vista/XP/2000/NT, Server 2003, Linux, UNIX.

ETL Tools:                SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data transformation services (DTS).

Third Party Tools:    Red Gate, Automate, Litespeed

Database Tools:         SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio.

Architecture:             RDBMS, OLTP, OLAP.

 

 

PROFESSIONAL EXPERIENCE

Employee’s Retirement System of Georgia (ERSGA)                                                 Apr 13 – Till-date

ERSGA manages retirement plans on behalf of the State of Georgia for the benefit of members, retires and beneficiaries. ERSGA administers plans for over 130,000 active and 52,000 retired Employees. ERSGA administers plans for Public School System, Legislative System, GA judicial System, GA Military Fund, Superior Court Judge Fund, and District Attorney Fund.  Responsible for administration of multiple Servers/Databases along with on-call support for all the production activity

SQL SERVER Developer &DBA

Responsibilities

  • Managed and administered SQL Server 2008/2008R2/2012 production and non-production servers.
  • Created Database Objects including Tables, Views, Constraints, Functions, Stored Procedures, Triggers, Rules, Defaults, and User Defined Data Types.
  • Identify relationships among tables and enforce referential integrity using foreign key constraints.
    • Handled development and production support, document reviews, test plans, and integration of the system.
    • Created Clustered and Non-Clustered Indexes to improve data access performance. 
    • Used Fog light Quest Software tool for troubleshooting, monitoring, and optimizing T-SQL code.
    • Implementation of SQL Logins, Roles, and Authentication modes as a part of Security policies for various categories of users.
    • Used SSIS packages to feed data to SQL server from different sources.
    • Creating and maintaining the scheduled jobs on daily, weekly and monthly basis.
    • Monitoring SQL Server logs to ensure whether the backup operations, batch commands, scripts have completed successfully.
    • Creating and maintaining Database Maintenance plans.
    • Check the developer’s code and deploy it in the production.
    • Used Log Shipping for synchronization of databases.

Environment: MS SQL Server 2008/R2/2012, Windows Server 2008R2 Enterprise, MS Visual Source Safe 6.0, SSIS, Fog Light.

 

MicroBilt Corporation, Kennesaw, GA                                                                           Dec 12 – Mar 13

SQL SERVER DBA & DEVELOPER

MicroBilt Corporation, is the single source and preferred provider of decision critical information that responsibly assists businesses in reducing risk and managing their business. MicroBilt provides online access to consumer and commercial credit bureau data with automated decisioning and collection services, MicroBilt is the leading provider of alternative credit data to businesses that want to offer credit and other financial services to underserved and underbanked consumers in the United States. MicroBilt is the most comprehensive single source provider of risk management solutions for the SME (Small and Medium Enterprise). Responsibilities Included migrating databases using SSIS packages from MSSQL 2005 to MSSQL 2008r2. Also was responsible for database administration.

Responsibilities

  • Managed and administered SQL Server 2000/2005/2008/2008R2 production and non-production Servers.
    • Migrated SQL Server 2005 databases into SQL Server 2008R2 databases.
    • Used SQL Sentry tool for troubleshooting, monitoring, and optimizing T-SQL code from developers.
      • Used Automate 9 tool to download files from servers schedule jobs and triggers.
      • Used Red Gate SQL to compare databases, backups and deploy schemas.
      • Creating packages, jobs, sending alerts using SQL MAIL and custom extended procedures.
      • Generated and scheduled reports daily using html in stored procedures.
      • Creating logins and roles with appropriate permissions.

 

 

Environment: MS SQL Server 2000/2005/2008/R2, Windows Server 2008R2, T-SQL, SSIS, Red Gate.

 

Avenger Engineering, Alpharetta, GA                                                                             Sep 11 – Nov 12

SQL SERVER DBA

Avenger Engineering is a Telecom Company which provide services to large and Small Network operators. The company makes software for telecom companies to improve their network Quality. Company provides different customized tools for the clients and also maintains databases of the network operators to analyze and improve their wireless networks. My responsibilities involved in designing SSIS packages, migrating databases from SQL server 2005 to 2008r2. Also responsible to monitor and tune large databases for performance and availability, modify database structures.

Responsibilities

  • Managed and Administered SQL Server 2005/2008R2 Production and Non-production Servers.
    • Migrated SQL Server 2005 databases into SQL Server 2008R2 databases by In-place upgrade process and also used upgrade advisor tool in up gradation.
    • Used SQL Profiler for troubleshooting, monitoring, and optimizing T-SQL code from developers.
      • Analyzed long running slow queries and tune the same to optimize application and system performance.
      • Implemented and maintained Replication (Transactional, Snapshot) using Dynamic Scripts.
      • Maintained Database Consistency with DBCC at regular intervals.
      • Extensively worked on Profiler, Perfmon, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
      • Scheduled weekly jobs and Maintenance tasks for better performance and created alerts with Database Mail SMTP.
      • Configured Database Maintenance Plans for Backups, Re-indexing, and Reorganization of Indexes, Cleanup History, and Update Statistics.
  • Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.
  • Setup Database Security and maintain accounts and access levels by creating suitable Logins and Roles and assigning object level permissions.

 

Environment: MS SQL Server 2005/2008R2, Windows Server 2008, T-SQL, SSIS, Litespeed.

 

DISD, Dallas, TX                                                                                                                  Mar10 – Sep11

SQL SERVER Developer &DBA

DISD is the 12th largest school district in the United States with almost 20,000 employees and 200,000 students. Information Technology department of DISD, uses Chancery student system to maintain the student data which consists of Enrollments, Grades, Special Ed info etc. Chancery is based on SQLSERVER with .net as a front end. I worked in a role of Consultant for DISD’s Student Systems IT team and as a part of my assignment, I was involved in maintenance of servers and databases, SSIS Packages and SSRS reports.

 Responsibilities

  • Microsoft SQL server 2008\2005 Database Administration.
  • Converting DTS Packages into SQL Server 2008 Integration Services.
  • Created Linked Server connections between SQL Servers databases.
  • Worked on multiple instances of SQL Servers using VM Ware.
    • Evaluated database performance, performed maintenance duties such as Tuning, Backup, Restoring, and Disaster Recovery.
    • Implemented Data Partitioning, Snap Shot Isolation, Database Mirroring, Database Snapshot, DDL Triggers, Try-Catch Blocks, Online Indexing, DMV’s, and DMF’s.
    • Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.
    • Performed backup using backup compression and data compression in SQL Server 2008 on clustered environment.
    • Worked on Log Shipping for database synchronization.
    • Export or Import data from other data sources like flat files using Import/Export through DTS and SSIS.
    • Configured the Report Server, Created, deployed, and managed Ad-hoc reports using SQL Server Reporting Services (SSRS).
    • Experience in using ERWIN tool for designing the data reporting databases.

 

Environment: MS SQL Server 2008/2005, Windows Server 2003, ERWIN, SQL Business Intelligence Development Studio 2008.

 

HDFC BANK, INDIA                                                                                           Jan 09 – Oct 09

 

SQL Server Developer

 

HDFC Banking Limited is the sixth largest bank in India and the largest bank by market capitalization. It is one of the fast growing banks in the ever growing banking sector in India. I was involved in database development using T-SQL.

 

Responsibilities:

  • Create Triggers to generate alerts and notifications.
  • Wrote complex stored procedures to map and read data from third party formats as part of statistical Data Migration.
  • Tune the SQL queries using SQL Profiler and Executions Plans.
  • Created Views to facilitate easy user interface implementation, and Triggers on them to facilitate consistency Data entry into the database.
    • Developed automated emails and generated dynamic RTF forms using OLE automation
      procedures.
    • Wrote queries involving multiple databases through linked server.

 

Environment: MS SQL Server 2000, Enterprise Manager, Windows 2000/XP.

 

EDUCATION

Bachelors in Computer Science, JNTU, Hyderabad 

  • ID#: 75711
  • Location: Alpharetta, GA , 30004

Don't Be Fooled

  • When selling, do not put your home address in your ad.
  • To avoid scams, buy and sell with people you can meet locally, in person.
  • When meeting with someone you don't know, meet in a public place. If that's not possible, have a buddy with you. Also, carry a cell phone; if you feel unsafe, you can call a trusted friend, and stay on the line.
  • Never give out financial or private information like account numbers, PayPal login, or social security number.
  • If an offer sounds too good to be true, it is. Walk away!

Look Who's Hiring!

Sr SQL Server DBA (Production)
Atlanta, GA Allscripts
SQL Server DBA
Atlanta, GA Capricorn Systems, Inc.
Database Developer & DBA - Oracle & SQL Server...
Atlanta, GA Visionaire Partners
SQL Server Developer DBA
Atlanta, GA eConsultants Inc
Premier Field Engineer- SQL Server
Atlanta, GA Microsoft Corporation
Sr Database Administrator - SQL Server
Alpharetta, GA RELX Group