Sql Server Development
Resume:
Anusha Akula
Email ID: *********@*****.***
Phone Number: 252-***-****
Summary:
• 5 years of experience in IT Industry with MS SQL SERVER DBA in Design,
Development, Administration and Management using SQL Server 2008R2/2008/2005 under
WINDOWS on a 24x7 large scale Clustered & non-clustered build environments and MSBI
(SSIS,SSRS using 2008R2/2008/2005).
• Good Knowledge on all phases of Software Development Life Cycle (SDLC) involving
Systems Analysis, Design, Development, Testing and Implementation.
• Good knowledge of Relational Database Management Systems (RDBMS).
• Expertise in installing SQL Server 2005/2008 and R2, service packs, hot fixes and
security patches and experience in migrations of SQL Server 2000/2005 to SQL 2008 &
R2.
• Proficiency and expertise in Backup and Restore databases, Disaster recovery
planning and Security Management.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity,
Database consistency checks using DBCC utilities.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows
Performance Monitor for tuning and monitoring SQL Server performance.
• Implemented and monitored different types of High Availability & Disaster Recovery
scenarios like Clustering, Replication models, Log Shipping and Mirroring.
• Extensively worked on Backup compression and data compression in SQL Server
2008.
• Expertise in resolving locks, deadlocks, handling Isolation level and concurrency
effects, detect CPU, I/O, Memory bottlenecks.
• Strong DBA development skills writing TSQL scripts, creating SSIS. Developed and
created various complex SSIS dtsx packages and deployed into File System Server and
Microsoft SQL Server using manifest file.
• Experience in creating SSIS packages using Control Flow Tasks like Data Flow Task,
For Each Loop Container, File System Task, Execute SQL Task, Transfer Database Task, and
Transfer Login Task etc... And Data Flow Transformations like Multi Task, Conditional Split, Look
up, Fuzzy Look up, Char in Microsoft SQL Server Business Intelligence Development Studio.
• Experience in creating complex drill down, matrix, drill through, cascading and
parameterized reports using SQL Server Reporting Services 2008R2/2008 /2005. Configured
and maintained reports using Report Manager and Report Server.
• Experienced in using third party backup tools like SQL Safe, VERITAS net Backup,
Tivoli.
• Strong technical background along with the ability to perform business analysis and
write effective documentation and specifications
• Experience in providing Production Support for 24x7.
Technical Skills:
Operating Systems: Windows XP/NT/7, Unix, VOS (Virtual Operating System) on Stratus
Mainframe.
Databases: MS SQL Server 2012/2008R2/2008/2005, Oracle
Microsoft Business SQL Server Integration Services (SSIS), SQL Server Reporting Services
Intelligence Tools: (SSRS), SQL Server Analysis Services (SSAS)
Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server
Management Studio.
Tools: Autosys Control-M, VSS, Microsoft Visual Source Safe, Beyond
Compare, MS-OFFICE, TAP (Trading Access Point) and UDP for TCP/IP
networking.
Languages: T-SQL, C, VB script, Visual Studio2005/2008/R2, XML, HTML and
VB.Net, PL1
Applications: Microsoft Office Suite, Acrobat Reader/Writer.
Education:
• Bachelor’s in Computer Science and Enginnering, Jawaharlal Nehru Technological
University, India
Certifications and Achievements:
• NCFM (NSEs Certification for Financial Markets) – Beginners Module in financial Markets.
• NCFM (NSEs Certification for Financial Markets) – Capital Market (Dealers) Module in
financial Markets.
(The above certifications are conducted by National Stock Exchange Of India Ltd and are
recognised by Securities and Exchanges Board of India - SEBI)
• Received appreciation from Client and TCS for the development of Alternate FPO in IPO
and Batch Optimisation and Different market timings in WDM.
Professional Experience:
Client: J.P.Morgan, Colombus, Ohio 2012 Jul – 2013 Jan
Application: SARA( Suspense Account Reconciliation Application)
Tata Consultancy Services, India
SQL Server DBA / BI
Responsibilities:
• Administrated and Managed SQL Server 2008R2 databases in Development and Testing
environments.
• Performed all basic Database activities like moving databases between servers, copy
databases etc…
• Transferred data (ETL) to Data ware house Environment using SQL Server Integration
Services by implementing SSIS package security, protecting packages, executing,
monitoring and managing them.
• Designing SSIS packages for the SARA application.
• Creating new scheduling jobs in autosys.
• Testing the application for the ETL part.
• Document and review of deliverables like analysis documents, design document and Unit
Test Plans.
• Maintain and track status of the defects.
• Experience in creating drill down, parameterized and cascading reports using SQL Server
Reporting Services 2008R2.
• Experience in generating Adhoc reports using SSRS.
• Performed code reviews to ensure high Software quality and participated in weekly team
meetings.
• Provided 24/7 Support for Acceptance & Development Servers of MS SQL Servers
Environment:
MS SQL Server 2008R2, Visual Studio 2008 R2 SSIS, SSRS, SSAS, Visual Source Safe (VSS),
Autosys.
Client: J.P.Morgan, Colombus, Ohio 2009 May – 2012 June
Tata Consultancy Services, India
SQL Server DBA / BI
Responsibilities:
• Administrated and Managed SQL Server 2008R2/2008/2005/2000 databases in
Production, Testing, QA and development environments.
• Responsibilities include the Production and Application Support for the Database and
Application Servers.
• Extensively worked on Installing, Configuring and Maintaining SQL Server
2008R2/2008/2005 Active/Active and Active/Passive Clusters with latest Service
Packs, Hot Fixes.
• Extensively worked on Log Shipping to synchronize the databases between primary
server and secondary server
• Extensively worked on Migrating SQL Server 2000 databases to SQL Server 2008R2 and
SQL Server 2005/2008 databases to 2008R2 and mentored other technical staff and
documented.
• Created Logins at Windows Authentication and SQL Server Authentication server level,
Users at database level and assigned database roles to the particular Users.
• Monitored SQL Server logs to ensure whether the backup operations, batch
commands, scripts have completed successfully.
• Used native tools like Database Tuning Advisor, Profiler and Activity Monitor for
performance analysis.
• Extensively worked on trouble shooting dead locks and fine-tuning of databases for
its performance using native SQL Server tools like profiler and performance monitor
• Created Maintenance Plans for database backup’s (.bak) files, transaction log backup’s
(.trn) files, database integrity checks, Index Rebuild and maintenance Cleanup tasks
• Scheduled regular Backup Jobs and kept track of database by receiving the emails on
Alerts
• Extensively working on performance issues like update statistics, Auto Stats.
• Configured Database Mail for sending failure job notification email messages from Jobs
and Procedures.
• Performed all basic Database activities like moving databases between servers, copy
databases etc…
• Transferred data (ETL) to Data ware house Environment using SQL Server Integration
Services by implementing SSIS package security, protecting packages, executing,
monitoring and managing them.
• Experience in creating drill down, parameterized and cascading reports using SQL Server
Reporting Services 2008R2/2008/2005.
• Experience in generating Adhoc reports using SSRS.
• Experience working with Autosys to automate jobs, change status of job, job recovery,
running SSIS packages in different environment of the life cycle.
• Performed code reviews to ensure high Software quality and participated in weekly team
meetings.
• Provided 24/7 Support for Production, Acceptance & Development Servers of MS SQL
Servers
Environment:
MS SQL Server 2008R2/2008, Windows server 2008/2003 SSIS, SSRS, SSAS, Visual Source
Safe (VSS), SSAM monitoring tool, Red Gate (SQL Compare and SQL Data Compare), RS
Scripter.
Client: National Stock Exchange 2008 May – 2009 Apr
Tata Consultancy Services
PL1, Appletree database
Responsibilities:
• Liaison with the client to gather the requirements and evaluate the feasibility of the same.
• Analyze, design & development of business and technical requirements and plan delivery
schedules
• Ensuring adherence to QMS and Project Procedures
• Document and review of deliverables like analysis documents, design document, causal
analysis report, functional specifications and system test specifications
• Maintain and track status of the defects encountered in the Integrated System Testing and
User Acceptance Testing (UAT) using Defect Tracking System
• To coordinate the version control activity and release of components in the user
acceptance and production environments [Configuration Management].
• Support for user-acceptance testing (UAT) for new versions
• To analyze the critical production problems and to provide the solution for the same within
the time frame specified in the service level agreement (SLA) with the client.
• Impart business and technical induction to the new team members.
Environment:
Pl1, Appletree database, TCP/IP, VSS(Visual Source Safe)
Contact this candidate