Sql Server Manager
Resume:
[pic] [pic]
SANDEEP VALLABHANENI
SQL SERVER DBA / DEVELOPER/ BI DEVELOPER
******.**@*****.***
Culver City, CA.
Cell: 860-***-****
PROFESSIONAL SUMMARY
. Over 8 years of experience as SQL Server DBA on various Windows
operating systems (Server 2000/ 2003/2008)
. Experience in Installation, Configuration, deployment, managing,
monitoring, tuning and patching of MS SQL Server 2000/2005/2008.
. Experience in Logical and Physical database design
. Experience in Data Modeling(logical to physical) using ERWin
. Experience in migrating the databases from one platform to another
. Experience in SQL Server performance tuning, database tuning
. Extensive experience with SQL Server and T-SQL in constructing
triggers, tables, user functions, views, stored procedures,
transactions, Cursors, indexes, user profiles, relational database
models, and data integrity.
. Exposure to T-SQL coding best practices, performing code review
. Experience in Capacity planning, growth and changes for SQL Server
architecture
. Good understanding of networking concepts
. Experience working in Oracle platform
. Experience with Integration Services [SSIS], Analysis Services [SSAS],
Reporting Services [SSRS], ETL
. Experience in analyzing execution plan, I/O statistics, index tuning
for SQL queries
. Experience in tuning and optimizing database performance and
throughput for high volume OLTP applications.
. Experience in database clustering and replication to ensure high
availability.
. Experience in creating, maintaining and optimizing database objects
. Good understanding of optimizing the performance of Structured Query
Language (SQL) query and non-query commands.
. Experience in developing Silverlight applications using .NET framework
3.5
. Expertise in troubleshooting SQL performance issues by using SQL
Profiler, Spotlight, windows performance monitor tool
. Experience Monitoring free space in tablespaces and extending or
adding datafiles to the tablespaces
. Implemented DB Mirroring, Log Shipping as high availability and
Disaster recovery solution.
. Experience in developing applications using C#, ADO.net
. Experience with Database Backup, Restore(PIT) and Disaster Recovery
Plans
. Experience in Query Tuning, SSIS, DTS package tuning.
. Experience in automating SQL tasks by scheduling jobs (using SQL
Server Agent)
. Experience in data migration from one data center to another
. Experience in troubleshooting and optimizing Stored procedures
. Experience in design and manage database import / export processes
. Experience in designing databases based on Functional Requirements and
system design for very large web applications
. Experience in designing and maintaining database schemas
. Good experience with the entire phases of Software Development Life
Cycle (SDLC) that include analysis, design, development, testing and
deployment.
. Experience in assigning proper privileges to the database users and
defining roles
. Experience in security considerations and availability considerations
for Data Migration
. Experience in Index Tuning, Performance Tuning, Query Tuning and
Change Management
. Experience in maintenance of the databases to include rollout and
upgrades
. Experience in Clustered and non Clustered indexes
. Experience in Designing, Developing, Testing and Deploying SSIS
packages
. Experience in creating and maintaining scripts for databases
. Good Knowledge of Relational database Design and implementation
. Experience in troubleshooting SQL performance bottlenecks
. Experience in collecting requirements from business users and
transforming them into Dimensional data models
. Good skills in optimizing the performance of the database and running
Database Consistency Check
. Scheduled jobs, alerts, SQL Mail Agent and DTS/SSIS packages in SQL
Server.
. Experience in developing user interface using Expression Blend 3/2
. Excellent knowledge of Silverlight 3/2
. Working knowledge of WPF/XAML
EDUCATION
Master's in Computer Science, Georgia State University, Atlanta, Georgia.
Bachelor's in Biotechnology, SASTRA University, India
TECHNICAL SKILLS
Languages: C#, Java, ForTran
Database: Oracle 10g, T-SQL, PL-SQL, MDX, SQL Server 2005 DBA,
Access,
ER Modeling, RA interpreter, XML Data Model and
query languages,
MS Office, OutlookSoft
Database Tools: Management Studio, Enterprise Manager, Query
Analyzer, SQL
Profiler, ER Win, SSIS, SSAS, SSRS,
Business Intelligence Studio, Export
and Import DTS.
SAS: SAS BASE/STAT/MACRO/ODS/GRAPH/IML
Web Designing: HTML, CSS, JavaScript, Java Servlets, XML, AJAX
Operating systems: Windows 98/2000/XP, Windows Server 2000/2003, UNIX
Tools: UML, Dia
Other Tools: R, S, Weka, NAMD, MEV, FASTA, BLAST, Clustal W
EXPERIENCE SUMMARY
E7 Studio, Los Angeles, CA SQL DBA/ Developer
May'09- Present
E7 studio provides Software solutions to Los Angeles Community College
District
Responsibilities:
. Setting up new SQL server 2008 and configuring the required users.
. Restoring and copying Production Databases.
. Regular monitor of servers, which includes Backup Job Monitoring and
troubleshoot all the issues on regular basis. Use of SQL Server
Integration Services to transform data.
. Developed applications using VB.net as frontend and SQL Server as
backend
. Resolved various performance issues.
. Administered MS SQL Server by Creating User Logins with appropriate
roles, dropping and locking the logins, monitored the user accounts,
granted the privileges to users and groups.
. Use of SQL Server Analysis Service to extract summary data.
. Performed Full Backups and Transaction Log Backups. Restored them
whenever necessary, created back up strategies and scheduled them for
execution.
. Administered Replication and Log Shipping.
. Plan and Schedule the Online/Offline Backups and Implemented Log
Shipping.
. Used Database Maintenance Wizard to make some necessary changes and
kept the performance of the server at an acceptable level.
. Developed Silverlight streaming application using Silverlight(C#)
as frontend and SQL Server as Backend
. Used Expression Blend 3.0 to develop the user interface for Kiosk
application
. Created templates for the Kiosk application using Expression Blend
. Designed the backend(database) for the Kiosk
. Developed web services using C#
. Developed the Kiosk application using C# as code behind
. Implemented High availability concepts like Database Mirroring and
Log Shipping
Technical Environment: Windows Server 2003, SOA Architecture, web services,
windows services, VMWare, Silverlight, C#, Expression Blend, Expression
Design
GE Health Care, Los Angeles, CA SQL Server DBA/Developer
Dec'08- May'-09
GE Healthcare has a broad range of products and services that include
medical imaging and information technologies, medical diagnostics, patient
monitoring systems, performance improvement solutions, drug discovery, and
biopharmaceutical manufacturing technologies. These enable healthcare
providers to better diagnose and treat cancer, heart disease, neurological
diseases, and other conditions earlier. The company's vision for the future
is to enable a new "early health" model of care focused on earlier
diagnosis, pre-symptomatic disease detection and disease prevention.
Responsibilities:
. Created and maintained various databases for development and testing
environment
. Performed daily backups and develop recovery procedures.
. Created and modified procedures, Triggers and Functions.
. Created Snapshot replication for the development and testing databases
across servers.
. Created schema objects, rules and granting of roles to the users.
. Created cubes for the analysis of data using SSAS
. Created SSIS Packages for the migration of data across different
servers and other databases such as Oracle.
. Setting up backups for the newly created databases.
. Scheduled transfer of Backup and Log files to a different server.
. Migrated databases from SQL Server 2000 to SQL Server 2005 in
development and test environments.
Technical Environment: Windows 2000/2003 server, MS SQL Server 2008, Visual
Studio,
T-SQL, DTS, Clusters, SSIS(Service broker), SSAS, SSRS, SQL Diagnostic
Manager,Visio, ERWin, C#
Message Technologies, Inc. SQL Server DBA/Developer
July'06- Nov'-08
Atlanta, GA
MTI is a leading provider of voice applications hosting, design,
development and services supporting every part of the Interactive Voice
Response and speech applications spectrum.
Responsibilities:
. Worked extensively on installation, upgrade and configuration of MS
SQL Server 2005 and MS SQL Server 2000 databases/ servers.
. Actively participated in gathering of User Requirement and System
Specification.
. Worked extensively on Database space management, performance
monitoring and alert management.
. Administered the MS SQL Server by creating user logins with
appropriate roles, dropping and locking the logins, monitoring the
user accounts, creation of groups, granting the privileges to users
and groups.
. Maintained security by creating users and giving appropriate
permissions to users.
. Scheduled the backups for Databases and Transaction log. Performed
restoration operations. Suggested backup strategies.
. Used third party tool lite speed for database backups and
restorations.
. Created Jobs and scheduled jobs according to the requirements.
. Implemented transactional replication between Primary Server and Sub
Systems.
. Created database, tables, Indexes and views.
. Created linked server between SQL servers.
. Dropped and recreated the indexes on tables for performance
improvements.
. Written complex stored procedures and functions and integrated it with
the front end application.
. Involved in performance tuning and query optimization.
. R&D for data-migration from MS-SQL to Sybase (linked-server, DTS
packages (API) and triggers)
. Worked with SQL server Profiler to generate traces.
. I have written unique database driven CMS (Content Management Systems)
in C#
. Data transfers between various servers using BCP and DTS.
. Extensively used SSIS to move data from text files to SQL Server.
. Created performance maintenance plan using SSIS
. Extensively used C# for coding the application.
. Created packages successfully using SSIS to transfer large volume of
Data.
. Implemented Row Level Security in Universe for different levels in the
organization.
. Developed several reports using SQL server Reporting services (SSRS)
. Extensively used SQL server reporting services for designing reports.
. Involved in migrating databases from MS SQL server 2000 to MS SQL
server 2005.
. Develop documentation that sufficiently describes technical
deliverable as required for internal controls so that the maintenance
responsibility can be passed on to production support team.
Technical Environment: MS Windows 2003 Server, SQL Server 2005/2000, BI
Development Studio, SQL Server Management Studio, Enterprise Manager, SSIS,
SSAS, SSRS, C#,IIS Server, Visual Studio.NET 2005, MS Visio.
Andhra Bank, AP, India SQL Server Developer/DBA
Mar'05- Jun'06
Andhra Bank is the community commercial bank located in Hyderabad, India,
which deals primarily with consumer banking, loans, and credit card
issuance.
Responsibilities:
. Created and modified Tables, Indexes. Stored Procedures, Triggers,
Views.
. Involved in optimizing queries, supporting SQL database processing
real time data, middle tier code optimization using T SQL advanced
level programming in 2000 and 2005 versions of SQL Server.
. Monitoring and optimizing the performance of the database, queries and
stored procedures offering assistance to developers in optimizing
their applications.
. Perform Daily Backups and Develop recovery procedures, involved in
planning for disaster recovery.
. Mail enabling the database server.
. Creating new jobs, scheduling jobs, and setting job
notifications/alerts.
. Creation of Schema owner and security access to databases users.
. Maintained Production, Test and Development servers.
. Setup and maintained Linked Servers.
. Setup and maintained Replication Servers.
. Created DTS/ETL Packages to pull data from Oracle and Flat files and
transformation of data into staging tables.
. Responsible for planning, executing, and maintaining data integration
projects and database upgrades.
. Writing trace log using SQL profiler to analyze instances running
production database.
. Managed and coordinate with remote user for change request and
optimization of application.
Technical Environment: Windows 2000, SQL Server 2000\2005, Enterprise
Manager, Management Studio, SQL Profiler, SQL Query Analyzer, Crystal
Reports and Reporting services, ETL: MS SQL Server DTS, SSIS, Upgrade
Advisor, DTS Designer Tools, Visual Studio and Windows Performance Monitor.
UI Insurance, Chennai, India SQL Server Developer/DBA
Feb' 04 - Feb' 05
DESCRIPTION:
UI is a leading General Insurance Company. The project required complete
migration of data from various existing applications to SQL Server.
Responsibilities:
. Successfully tested and implemented Log Shipping Technique used for
backup solution for MS SQL Server 2005 & 2000 databases.
. Backup and recovery of production databases and tuning production
databases for better performance.
. Created and monitored Database maintenance plans for checking database
integrity, data optimization, rebuilding indexes and updating
statistics.
. Monitored Performance Monitor and SQL Profiler to optimize queries and
enhance the performance of database servers.
. Maintained security tasks like granting and revoking permissions.
. Configured and worked on Replication server.
. Created and managed tables, functions, indexes using T-SQL in
development and Production environment.
. Developed stored procedures, triggers and functions based on project
requirements.
. Created user logins and adding users to respective databases.
. Created automatically running stored procedures for day-end operation
using SQL Server agent.
. Performed Backup, recovery and Automation of Backup
Technical Environment: MS SQL Server 2000, T-SQL, SQL Query Analyzer,
Windows NT, Profiler, DTS, Microsoft Excel
Reliance Communication Ltd, India SQL Server Developer/DBA
Jan' 02 - Feb' 04
DESCRIPTION:
Reliance communication is India's largest private telecomm provider,
Reliance Communications Limited is presently operating Cellular Phone
Services in all over India, considered as one of the best service providers
of mobile telephony in India. I was involved in creating databases,
creating data transformation services package, creating maintenance plans,
supporting administration applications for analyzing and loading data
Responsibilities:
. Responsible for 24*7 Critical Production Support for 75 servers out of
which 30servers are production servers, remaining test and development
servers.
. Installed SQL Server 2000 on windows 2000 and 2003 servers, Installed
service packs and security fix on production, test and development
servers.
. Installed, configured and maintained MS SQL Fail over clustering for
production servers to provide high availability.
. Configured and maintained the transaction and merge replication for
two different projects.
. Involved in upgrading from SQL Server 7.0 servers to SQL Server 2000.
. Designed the logical and physical database design for development
projects using Erwin data modeling tool.
. Configured and maintained two log shipping environments to create the
backup server.
. Experienced in involving SQL Server performance using index tuning
wizards, SQL Profiler and SQL Query Analyzer.
. Created the DTS packages to import and export the data from Oracle, MS
Access and text files to SQL Server.
. Experienced in creating backup strategy for production, test and
development servers.
. Involved in disaster recovery procedures and restore the production
databases.
. Involved in database restore requests and refresh the database between
productions, test servers.
. Created checklists to install SQL Server installation, service packs,
security fix and MS SQL cluster installation.
. Experienced in creating logins and assign the permissions to
databases. Maintained the SQL Server in secured environment.
. Experienced in trouble shooting database issues and maintains the SQL
Server to provide maximum availability.
. Created the maintenance plans for integrity checks and optimization
for production, test and development servers.
. Document server and database policies and procedures.
. Involved in database sizing projects and projected the database
growth.
. Involved in change Management processes using remedy software.
. Experienced with restoring the database between production and test
servers.
. Created checklist for SQL Server and Cluster installation, Appling the
service packs and security fix.
. Created documentation to install SQL Server, apply service pack, hot
fix and clustering installation.
. Excellent team player with good communication skills.
Technical Environment: MS SQL server 2000, Enterprise manager, Query
analyzer, SSRS, Windows 2000, DTS, SQL profiler.
Dr Reddy's Laboratories Ltd, India SQL Server Developer/DBA
Jan' 01 - Dec' 01
Dr Reddy's Laboratories is India's second largest pharmaceutical company
DESCRIPTION:
. Installed, configured SQL Server 6.5 and 7.0 on windows NT4.0, 2000
server platforms.24*7 production support for 94 servers.
. Involved in upgrading the MS SQL Server 6.5 to SQL 2000.
. Installed and configured the transactional replication for 2
environments.
. Responsible for User administration and granting permission to the SQL
Developers and application users.
. Migrated the database from MS SQL Server 6.5 to SQL 7.0.
. Provided 24 X 7 dedicated supports to all Production, Test and
development servers.
. Created the logical and physical database design.
. Monitoring activities and making recommendations on Server
configurations, Backup and restore, naming standards, development
standards and new Installations.
. Tune the Complex SQL Queries for performance improvement.
. Created the backup strategy for production environment.
. Application tuning, scripting, security and user administration, space
management and forecasting, jobs scheduling, replication setup and
maintenance, etc.
. Used DBCC to check physical and logical consistency of the database.
. Created the documentation for database standards.
. Created Logical and physical data modeling for databases using Erwin.
. Involved in creating tables, indexes, stored procedures and triggers.
. Optimized the database to improve the performance, helped the SQL
Server developers to tune the Queries.
. Involved in database backup and restore operations.
. Imported the data to MS SQL Servers using DTS Packages.
. Used DBCC commands to check the consistency of the databases.
. Created the documentation for production server changes.
Technical Environment: SQL Server 6.5,7.0, Erwin, DTS, MS Mail Service,
SQL Profiler, Query Analyzer
Contact this candidate