Sql Server Manager
Resume:
____________________________________________________________________________
___________________________________________________________
Sridhar Tatineni
** ***** **, ****** ** 08820
Phone: 732-***-**** Email: ***.********@*****.***
____________________________________________________________________________
___________________________________________________________
Executive Summary:
. 16 years of IT experience and 10 of these years working as SQL Server
Database Administrator.
. Extensive experience in installation and configuration of MSSQL Server
2008/2005/2000/7.0/6.5 versions.
. Experience in building and supporting SQL Server 2008/2005/2000
Active/Passive and Active/Active Clusters
. Expertise in planning and implementing MSSQL Server security for SOX.
. Experience in Database Backup, Recovery and Disaster Recovery
procedures.
. Experience in implementing Snapshot, Merge and transactional
Replication.
. Extensive knowledge in Building/Supporting Business Intelligence &
Data warehousing applications.
. Experience in Installation/Configuration/Support of SharePoint
Services.
. Experience in writing and debugging Stored Procedures, Functions and
Triggers.
. Extensive knowledge in Configuration/implementation of Analysis
Services and Reporting Services in Web Farm Environment.
. Experience in Configuring and supporting Kerberos Security across
multiple environments.
. Experience in Data modeling using ERWIN and Enterprise Architect for
UML modeling.
. Experience in Creating ETL Packages using SSIS & DTS.
. Experience in Performance Tuning, Query Optimization, Client/Server
Connectivity, and DBCC Utilities.
. Proficient in writing programs using Java, VB, C Sharp, PowerShell and
.NET
. Experience in using Cognos 8 BI tools (Framework Manager, Report
Studio, Analysis Studio, Metric Studio, Event Studio, Query Studio,
Cognos Connection, Impromptu Administrator & Impromptu Web Reports).
. Proficient in designing and building business logic using Cognos
Framework Manager.
. Good knowledge of Dimensional Schema models (Star Schema, Snow-Flake,
and OLAP).
. Worked on complete Life Cycle Development process, which includes
analyzing business needs, documenting business information
requirements, technical designs, development, integrating,
Implementation and Production Support using Cognos as a BI tool.
Experience:
Prudential Finanacial. Oct 2009 -
Present
BI Architect/DBA
Technologies-
. Microsoft - SQL Server 2000/2005/2008R2, Integration Services,
Analysis services, .NET, C#
. Cognos 8.0/8.4, ERstudio
. Windows 2000/2003/2008, Unix, VMWare.
Main Responsibilities-
. Developed Prudential Mutual Funds full current and future Business
Intelligence Roadmap.
. Re-Designed BI technical architecture
. Gathered requirements from all aspect of business.
. Designed and modeled Enterprise Data Warehouse (EDW) utilizing Star
Schema methodology using Erwin Data modeler tool.
. Designed and developed Operational Data Store (ODS) to store
Aftermarket sales data provided directly from ODS to Sales portal.
. Designed Staging area to host data for both ODB and EDW.
. Create Migration roadmap to Move Sql Server 2005 Datawarehouse to Sql
Server 2008R2
. Create Migration roadmap of existing Powerplay Environment from Cognos
8.0 to Cognos 8.4
. Created SSIS Mappings, Workflows & Sessions to automate data from
External Systems to ODS.
BNP Paribas Equities & Derivatives. April
2009 - Oct 2009
-Senior Database Administrator
Technologies -
. Microsoft - SQL Server 2000/2005/2008, Integration Services, Oracle
11G, Sybase
. CA Unicenter, Oracle OEM Manager, Powershell, REMEDY
. Windows 2000/2003/2008, Unix, VMWare
Main Responsibilities-
. Responsible for Production Support of SQL Server and Oracle Databases
in a 24/7 Environment.
. Install, Configure and support SQL Server 2000/2005/2008 Databases in
Windows and VMWare platforms.
. Administration and monitoring of Oracle Servers.
. Support Sql Clusters, Mirroring and Replication.
. Responsible for Database Administration: Backups, Restores, Disaster
Recovery, SSIS, job creation and scheduling.
. Create Powershell Scripts to monitor SQL Server Services, Backups,
Space, Jobs, blocking, Log, mirroring and alert DBA Group.
. Evaluated tools like CA Unicenter, Oracle Grid for monitoring of
Sybase, SQL Server and Oracle Databases.
. Create an Inventory of all Database servers across North America, to
monitor SQL Server Version, Patch Levels and to check compliance for
Audit and security.
. Documentation.
Max Capital Group. Nov 2008 -
April 2009
-Senior Database Administrator
Technologies -
. Microsoft - SQL Server 2008, Integration Services, Reporting Services,
Analysis Services, and SharePoint Services, Visual Studio Team Server.
. Enterprise Architect, TFS
. Windows 2003/2008, IIS 7, VMWare
Main Responsibilities-
. Create SQL Server 2008 Active/Active Cluster in Production.
. Install Maintain and Support databases and configuration of SQL Server
2008 Cluster in production, UAT, QA and development environments.
. Install, Maintain and Support Analysis Services in Cluster
Environment.
. Configure and Integrate Multiple data sources from
Oracle/SQLServer/Flat Files/Excel into Production DW Environment.
. Setup Sharepoint and Integrated Reporting Services in a Web Farm.
. Setup II7, Application Request Routing (ARR) protocol to load Balance
Web Farm Environment.
. Setup Kerberos Security End to End to support multi hop User security.
. Customize Visual Studio team server modules(Project Real) to simulate
100 Concurrent user load on Analysis Services for stress testing.
. Setup AD Groups, and integrate them into Analysis Services Cube roles
to enable content filtering based on Business role and Global
location.
. Create/Manage/Support SSIS packages in production.
. Work with Data Architect in Designing ODS and Star Schema for
Reporting.
. Responsible for Database Administration: Backups, Restores, Disaster
Recovery, SSIS, job creation and scheduling.
. Change Management was done using Microsoft TFS.
. Provided on-call 24/7 support .
Akken Inc. July 2006 -
Aug 2008
-Senior Database Administrator
Technologies -
. Microsoft - Visual Studio, Integration Services, Reporting Services,
Analysis Services, and SQL Server 2005/2008, IIS
Main Responsibilities-
. Responsibilities included managing all processes related to database
administration: Installations, Backups, Restores, Disaster Recovery,
DTS, SSIS, job creation and scheduling.
. Performed profiler to monitor, report on database performance issues
and index tuning using SQL Server.
. Migration of SQL Server 2005 to 2008 in Dev and Test environment.
. Setup/Configure replication for high availability.
. Performed user and security administration activities.
. Maintained large databases which include GB of MSSQL Server databases.
. Managing maintenance plan for full backup, transactions log shipping
backup and schedule the jobs.
. Involved as a team member in designing this data model.
. Day-to-day activities such as backups to the disk and restore the
databases and transaction log on production/development servers as per
business/IT needs.
. Good experience in ETL using SSIS packages uploading the data from
source to destination.
. Coordinating with business units to make sure the change request as
per their requirement and functionality will be completed as per the
schedules in production, development, application and UAT.
. Provided on-call 24/7 support regarding production-related database
problems.
Prudential Finanacial.- July
1996 - June 2006
Systems Manager/Senior Database Administrator
Technologies-
. Cognos-Enterprise Planning, Powerplay, Report Net, Cognos 7/8,
Powerplay Enterprise Server, Metric Studio, Business Intelligence 7,
Access Manager, and Impromptu Query Definitions.
. Windows NT, Windows Server 2003, Unix, IIS
. Microsoft SQL Server 6.5/2000/2005, Sybase system 11, Oracle, DB2 UDB,
SQL Any where
. Microsoft VBA for Access and Excel, Crystal Reports, MSProject,
Main Responsibilities-
. Installed and configured SQL Server 2005 components in production and
development environments.
. Configured SQL Server 2000/2005 Reporting Services and migrated MSSQL
Server 2000 to MSSQL Server 2005.
. Responsibilities included managing all processes related to database
administration: backups, restores, disaster recovery, data modeling,
installations, DTS, job creation and scheduling.
. Configured the database mirroring and log shipping to stand by server
(automatically restore).
. Performed profiler to monitor, report on database performance issues
and index tuning using SQL Server.
. Performed user and security administration activities, such as
enrolling users, granting privileges to users and maintaining system
security.
. Managed maintenance plan for full backup, transactions log shipping
backup and to schedule the jobs.
. Created the databases, tables, indexes, views, triggers, RI
constraints, infrastructure related stored procedures, transforming
and loading of data using DTS package.
. Day-to-day activities such as backups to the disk and restore the
databases and transaction log on production/development servers as per
business/IT needs.
. Coordinated with clients to make sure the change request as per their
requirement and functionality will be completed as per the schedules.
. Provided on-call 24/7 support regarding production-related database
problems.
. Provide an advanced level of analysis, design, and hands-on
development on business intelligence, reporting, systems
installations, Process Improvement and planning projects.
. Play a primary role in the functional development, technical
development, testing, and implementation of global systems for
Prudential Sales Force.
. Provide project management on cross functional projects including
functional requirements gathering, facilitating meetings, managing
scope creep, testing, and documentation.
. Maintain existing data warehouse system, software, and troubleshoot
daily production issues to ensure application uptime.
Programmer Analyst
AT&T - February 1995 to July 1996
Technologies-
. Windows 3.11, Windows NT 3.5
. UNIX, C, Visual Basic 4/3, Excel 5
. MS SQL Server 6, MSAccess 2.0, Ingress
Accomplishments-
. Created front end applications using Visual Basic and "C" to access
data from Back end Ingress financial systems.
Main Responsibilities-
. Design and development of Client & Server modules Using Visual Basic
and C.
. Communication between client and server (Socket programs) were written
in C.
Programmer Analyst
Victoria DP Inc-February 1994 to December 1995
Technologies-
. Windows 3.11
. Languages-Visual Basic 2, OLE2.0, ODBC
. Microsoft Access
Accomplishments-
. Provided Front End support, requirements gathering, business analysis,
and computer programming for the customer/product profitability
system.
Main Responsibilities-
. Provide analysis, design, and hands-on development for systems
installations and process improvement.
. Play a primary role in the functional development, technical
development, testing, and implementation of customer service
applications.
Education & Certifications
. BS, Osmania University.
. MS Electrical Engg, Texas A&M University.
Contact this candidate