Sql Server Data
Resume:
R AJ
r *****@*******.***
E XPER IENCE SUM MARY
• Has been working as a Database Administrator with 6 years of I nformation
Technology experience including Database Administration, Development,
Configuration M anagement, Analysis, Design, and deployment with MS SQL Ser ver
2000/2005/2008 an d Oracle databases 9i/10g.
• Expertise in setting up the DBA environment, documenting build and deployment
p rocesses in SAN Environment. E xperienced in data center server consolidation and
u tili ty computing in a vir tualized environment projects.
• Involved in working with the system/storage administrators to appropriately spread
data and log files across the SAN to avoid spindle contention of a database.
• Strong experience in installation, upgrades, service packs, database migrations,
backup, recovery .
• Experienced in Migrating and Tuning T-SQL scripts, indexes, stored procedures and
v iews. Tuning and optimization of SQL queries and stored procedures using SQL
P rofiler and Performance monitor and ensuring indexes are using updated statistics.
• Experienced in configuring, supporting and t roubleshooting high availability
solutions such as Log shipping, Database mi r roring and Replication topology and
k nowledge of SQL Server Clustering.
• Ex perienced in the migration and implementation from other relational databases to
M S SQL Server 2000/MS SQL Server 2005/ MS SQL Server 2008.
• Very strong DBA skills such as backup and disaster recovery, performance
monitoring and improvements and daily preventive maintenance of multiple SQL
Servers on Windows 2000/2003/2008 Servers.
• Good Working knowledge of SQL Server tools like SQL Server Management
S tudio, SQL Server Profiler, SQL Server Agent, SQL Server Surface Area
Configuration, Database Engine Tuning Advisor, BCP, I ntegration Services.
• Experienced in design, creating, configuring, t rouble shooting, implementation and
maintenance of large Business Intelligence environment in Dev, QA and Prod
environment.
• Experienced in Audit, in implementing D BA standards, methods, processes and SOX
controls across all servers and databases.
• Knowledge of Cit r ix Xenapp clients and VMware infrastructure.
• Experience with Payment card industry data security compliance.
• Good knowledge of configuration management concepts, release management,
changes management concepts, Industry standards and best practices.
• Trouble shooting on network issues with T CP/IP and protocol and also responsible
for client configurations.
• Experienced with d ata modeling tools, data analysis tools, E D I data mappings
tools, design and development, scheduling batch jobs and t roubleshooting jobs, load
estimations and load tests.
• A team player with strong leadership skills apart from solid technical and analytical
skills.
• A quick learner that strives for new technical knowledge & ability to communicate
w ith all levels of corporate personnel.
• Experienced with M icrosoft.Net Architecture & J2EE A rchitecture technologies.
EDUCAT ION Master of Science from Texas A&M University.
B achelor of Technology from Jawaharlal Nehru Technological
U niversity, I N D I A.
T ECHN ICAL SKILL SET M C I TP, MCTS in SQL SERVER 2005.
Technical Skills:
Relational Databases: SQL Server 6.5/7.0/2000/2005/2008,Oracle 9i/10g, Sybase 10/12.0.
SQL Server 2005 Reporting Services (SSRS).
SQL Server 2005 I N TEGRAT ION SERV ICES (SSIS).
M icrosoft Visual Studio 2005.
.
Operating Systems: U N IX, W indows 2000 Server, Windows 2000 Advanced server,
W indows 2000/2003/2008, W indows NT 4.0, Windows XP.
Languages: T-SQL, ASP.NET, PERL, H T M L, D HT M L, XML, CSS.
ETL Tools: D TS, Server 2005 In tegration Services (SSIS).
STORAGE: I B M, Compellent
AUD I T TOOLS: Symantec Bind view, Qualys and Splunk.
Data Modeling : CASE tools Erwin and Designer 2000.
Tools: V M-Ware, Remedy action request system, PGP-encryption Software, I IS Web
Server X.0 Web Logic Server X.0, CLEARCASE 2003, VSS 6.0, Star Team, Toad, SQL
Compare.
WORK EXPERIENCE
B BVA BANCOMER,
Houston. Sep’ 08 to Till Date
R ole: Database Administrator
D escription:
Ban comer Transfer Services (BTS), the subsidiary of BBVA banking group and the
leading provider of US money t ransfers, with around 40% market share.
BTS backend systems are managed with DBA process, procedures and policies. M S SQL
Server 2000/2005/2008 32 bit/64bit infrastructure being used as a backend database to
support distributed environments, manage high volume of OLTP data and OLAP (Data
warehouse data)
R oles & Responsibilities:
• As a Database Administrator i nvolved in daily monitor & maintenance, capacity
p lanning, hardware planning and configuring SQL server instances on Windows
environment.
• Involved in configuration of new maintenance strategies on SQL servers with
appropriate parameters.
• Developed, implemented, and maintained policies and procedures for ensuring
t he security and integrity of SQL Server 2000/2005/2008 databases.
• Involved in setting up SQL Server Agent jobs for Periodic Backups with Backup
Devices, Database Maintenance Plan and Recovery.
• Worked closely with other teams in disk subsystem capacity planning, file system
layouts, disk space and other database-related issues.
• Involved in SQL security and planning; administrating and creating user
accounts for proper access to SQL Server system databases and tables, SQL
P rofiler and Enterprise Manager, and Server monitoring to ensure adequate
CPU, disk space, and memory on all SQL servers.
• Involved in T-SQL query optimization using SQL query execution plan and Index
t uning wizard . Maintained logical and physical databases and reviewed
descriptions of changes to the database design. Involved in maintaining and
m igration of SSIS/DTS packages.
• Involved in resolving database performance issues, database capacity issues,
replication, and other production related distributed data issues.
• Development of Stored procedures, T-SQL queries, t r iggers based on the project
requirements.
• Involved in supporting two node cluster servers and databases and involved in
QA refresh, user data preparation, data scrubbing activities.
• Involved in managing system databases, database files, and t ransaction log files
and configuring the file in appropriate disks for achieving high performance
database.
• Involved in setting up Reporting services, Analysis services i n SQL Server 2005
and Involved in m igrating SQL Server 2000 Reporting Services RDL files to SQL
Server 2005 and maintaining and migration of SSIS/DTS packages.
• Migration of MS Access, Excel Objects to SQL Server 2000/2005 and Maintained
existing third-party and in-house developed database applications.
• Involved in Database Designing, Logical, Relational Database Diagrams,
Physical Data Modeling and Normalization process.
• Respond to t rouble t ickets assigned to me and fix any database issues promptly.
U pdate and work on projects that I have been assigned to as a resource from the
Database Management team.
• Troubleshoot database and database-related errors; made database changes
and/or worked with vendors, technical support staff, and users to resolved issues
and problems.
• Applied vendor-provided software upgrades and patches to the database
management systems and applications software, where database-specific
expertise was required.
• Responsible to releases from development to test to production environments.
• Timely execution of Change Requests. Participating in the On-Call Schedule and
Developer support for all Database related questions.
Environment: Windows 2000/ 2003/2008 servers, SQL Server 2000/2005/2008,
Q uest Fog light, MS ACCESS 2003,SSIS 2005,SQL profiler, M S-Office Tools,
V Mware I nfrastructure Client, MO M, Orion performance monitoring tools.
FedEx,
Memphis,TN Oct’ 07
to Sep’ 08
R ole: Database Administrator
D escription:
FedEx is one of the world's great start-up that revolutionized the delivery of packages
and information. FedEx revenue systems engine is coupled with multiple applications
and multiple environments. The non-legacy system i.e. backend systems are managed
w ith DBA procedures and policies. The non-legacy systems are developed with J2EE and
M icrosoft technologies. The distributed environments used SQL Server infrastructure as
a backend database to manage high volume of data.
R oles & Responsibilities:
• Monitor and maintain SQL Servers in Production, QA, Test and Development
E nvironments
• Verify backups and error logs on the servers and t roubleshoot any failures or
a lerts, open t rouble tickets if necessary to work with technicians from other
departments
• Respond to t rouble t ickets assigned to me and fix any database issues promptly.
U pdate and work on projects that I have been assigned to as a resource from the
Database Management team.
• Primary on call support duties for a week every month, which include monitoring
servers hosting SQL Server and customer’s SQL Server databases and work with
network operations resolving any production problems
• Involved in monitoring and maintaining multi node clusters servers, replication
databases, log shipping applications and stand by servers on Windows 2000/2003
environment
• Involved in T-SQL code, review meetings and test the code in test environment
• Development of Stored procedures, T-SQL queries, t r iggers based on the project
requirements
• Developed logical databases using Erwin and Visio tools.
• Follow change control procedures to migrate code into production servers.
• Actively involve and participate in team meetings and author how-to documents
and knowledge base articles for various database related tasks
• Upgraded over 10 servers from SQL Server 2000 to 2005 Enterprise and
S tandard edition
• Provided 3 different high availability SQL Server 2 node clustered environments
for various applications
• Implemented Log-Shipping as high availabili ty solution using both Enterprise
and Standard SQL Server 2000/2005 editions.
• Responsible to releases from development to test to production environments
• Automated backup and recovery processes throughout the environment
• Automating DBA activities using WHS services.
• Migrating and Tuning SQL scripts, indexes, stored procedures and views
• Helping developers in migration process of application code
• Conducting test runs and identifying migration issues and resolving those issues
• Implemented Database t r iggers, security, performance Tuning, Installs and
U pgrades.
• Involved backup setups using VERITAS services and monitor the server using
M OM.
• Timely execution of Change Requests. Participating in the On-Call Schedule and
Developer support for all Database related questions
• Creating and maintaining functional specifications, technical specifications as
well as t raining documentation for DBA related processes
• Providing weekly and monthly status reports
Environment: Windows 2000/2003/2008, M S SQL Server 2005/2000 32 bit/64bit,
V Mware I nfrastructure Client, MO M.
3. Progressive Technologies, I ndia Jun 03 -
J uly 06
Role: Jr. Database Administrator
The application has been developed to support multiple activities such as customer
details, credit scores and credit worthiness etc. The application is using multiple SQL
Server 2000 instances and databases in ordered to support Development, QA and
P roduction environments.
• Responsible for the overall performance, tuning, backup/recovery of all
installed SQL Server 2000 development, QA and Production Servers.
• Used SQL query language, stored procedures, views, indexes, constraints,
and referential integrity in development support.
• Involved in T-SQL query optimization using SQL query execution plan and
Index tuning wizard Managed database structure, table spaces, objects,
and files.
• Involved as dev DBA and verified and ran T-SQL scripts wri t ten by
programmers in Dev, QA and PROD.
• Involved in Maintenance and Monitoring of all Instances of SQL 2000.
• Involved in setting up DTS, Reporting services and Analysis services.
• Developed and modified DTS packages, stored procedures, t r iggers and
scheduled tasks in the support of data import/export and application
development.
• In a team environment, successfully designed, test and deploy database schema.
• Worked closely with other IT team members to successfully maintain and
monitor the SQL servers.
• Worked closely with R&D to identify any possible performance
bottlenecks.
• Planned and implement database upgrades and service packs as needed.
• Wri te custom scripts to automate various daily DBA operations.
• Implemented, managed and maintained data models, database designs, data
access, and table maintenance.
• Developed, implemented and optimized new and existing stored procedures,
functions and views.
• Resolved database performance issues, database capacity issues and other
p roduction related distributed data issues.
Environment: Windows 2003, M S SQL Server 2005/2000 32 bit/64bit, D TS, Query
a nalyzer.
Contact this candidate