SUMMARY

An enthusiastic technology professional with a sound understanding of banking and
Brokerage industries and their business processes. Possesses excellent communication
Skills and people skills with a nice blend of technology and business.
Experienced SQL Server DBA, responsible for planning, developing, and implementing IT solutions using SQL Server. Breadth of knowledge and experience in data management, design and database administration from a variety of positions and industries. Expertise includes researching problems and resolving situations with cost-saving solutions. Exceptionally adaptable and quick learner. Communicate exceptionally well with end users, staff employees, and senior management. Lead by example, integrity, and focus on quality solutions that serve both the customer and the organization.
An effective communicator with exceptional relationship management skills with the ability to relate to people at any level of business/management. A team leader with abilities in performance evaluations, team building, mentoring, demand forecasting.

Objective
Seeking a challenging opportunity as a Database Administrator or better, that can utilize my knowledge and extensive experience in database administration, design and performance tuning.

Specific expertise in the following:

Summary:
Over 11 years of IT experience in Database Administration mostly in financial sector.
Collaboration in the design of databases, emphasizing performance, integrity and usability.
Support high availability database management system.
Database builds and deployments, change control and change tracking and RFC.
Strong knowledge of SQL Server security procedures, database security audits, SQL installations, upgrades, migrations, consolidations, VMWare, data center migrations.
Architected and administered multiple database servers in 24x7x365 environments by installing and configuring SQL Server for optimal performance on clustered and standalone machines.
Design/Implement new projects and participate in re-engineering applications from scratch.(BIG IP/3DNS) Functioned as Subject Matter Expert.
Establish and document DBMS operating standards and procedures. Establish and maintain backup and recovery processes for all DBMS environments.
Experience of upgrade and migration from earlier version of SQL Server to SQL Server 7.0 and SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 in different environment.
Expert Level skills in providing 24x7 DBA supports in Production, UAT, SIT and Development environment.
Skills in Designing Physical and Logical data modal with Erwin Tools.
Implemented and supported high availability solutions like Clustering, Mirroring, Log shipping.
Expert in monitoring SQL Server Performance using SQL Profiler, Index Tuning Wizard, Windows Performance Monitor.
Expert in designing disaster recovery model for corporate databases.
In-depth knowledge of Transact-SQL (DDL, DML, DCL)
Expert Level Skills in Backups and Restore database operations, designing and executing SSIS packages.
Expert in Data Extraction and Transformation using Data Transformation Service (DTS), SSIS, Bulk Insert, BCP.
Experience in designing and implementing business specific replication models (Models Snapshot, Merge, and Transactional).
Experience in configuring and implementing SQL Server 2000/2005/2008/2008R2 Reporting Services (MSRS).
Configuring and Implementing Database Mirroring, Log Shipping, SQL Mails, Database Mails, Service.
Skills in Optimization and Tuning of Microsoft SQL Server for Windows NT, Windows 2000/ 2003/2008/2008R2 Servers platform etc.
Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
Experienced with different phases of project life cycle (project requirement, project initiation and specification gathering, design system, coding, testing) and debugging new and existing client-server based applications. Proven ability to adopt new technologies in minimum time and with little training.
Experience in database consolidation
Responsible for all external/internal audits deliverables and findings.( Finance, Marketing, and HR Infrastructure)

Professional Profile

Confidential, Jul. 2009 – Aug 2012
Senior SQL Server DBA

Primary DBA resource responsible for the build-out, administration and management of the Firm’s database environment, including installation, maintenance, upgrade, and 24/7 monitoring and support of all Microsoft SQL Server 2000 and SQL Server 2005 (32-bit, 64-bit), Microsoft SQL Server 2008/2008 R2 (32-bit, 64-bit) installations over the production, disaster recovery (DR/COB), staging and development environments.
Day-to-day tasks included production support and rudimentary change management, with heavy developer and vendor interaction (3rd party software support), client connectivity support, systems monitoring, general troubleshooting and performance tuning, as well as full documentation of database management roles and responsibilities, standard build guidelines, and database environment configuration. Provided extensive database support for DR testing, per investor requirements
To proactively monitor the SQL Server database systems to ensure secure services with minimum downtime. Monitoring and troubleshooting alerts generated by Tivoli in Production, COB, and UAT environments.
Work to ensure that the associated hardware resources allocated to the databases and to ensure high resilience and performance tuning.Responsible to attend project and Business meetings to determine scope and resource requirements. Provide any management escalations. Validate project designs and adherence to BOA Database and Security standards.
Ensure appropriate levels of Software are installed and upgraded to the latest supported levels. Provide roll-out of each DBMS level in co-ordination with Business objectives.
Reduce complexity through standardization of tools sets. Migration of existing practices/ scripts to the new Global standard product sets. Make recommendations to process improvements.
Responsible for improvement and maintenance of the databases to include rollout and upgrades.
Manage major software upgrades for SQL Server 2000\\2005\\2008\\2008R2 rollouts and SP upgrades. Including tracking of associated vulnerabilities and patches.
Responsible to Review, approval and support for Business /client sponsored Changes and associated Database Activities. Especially, for critical and financial impacted applications.
Responsible for implementation and release of database changes according to agreed timescales and costs.
Responsible to support for any external/outside audit requests. Collection, analysis, evaluation and validation of all evidence for the Distributed Database platforms for the quarterly Business Monitoring reviews. Develop remediation plans for any findings uncovered.
Scheduling SSIS jobs (SQL Agent), Migrating DTS packages to SSIS packages.
Work with project teams for upgrading different versions of SQL Server versions.SQL 2000/2005/2008/2008 R2
Setting up, Configuring and troubleshooting Log Shipping, Database Mirroring for databases on COB (Continuity of Business) servers. Working with businesses to design COB\\DR strategy.
Configuring and Setting up SQL Server Replication. Troubleshooting SQL Server Replication issues.
Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc. as required and implemented production/development servers as per business / IT needs by using industry & company standards in database management
Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler, Performance Monitor etc.
Design and implement Backups and Restore database policies.
Migrated data from different sources including flat files, MS Access, Oracle 11i to SQL Server 2008 by using SSIS. Installed multiple clients and resolved 32/64 bit driver. Worked heavily with BBDA (for server builds), Foglight (for monitoring), and LiteSpeed (for backup compression).
Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency and implemented security and auditing procedures of 3,321 MS SQL servers with a total of 4,014 instances and 36,914 databases.
Studying requirements of the client based on information and documents.
Designing Logical and Physical Data Model with Erwin tools.Functioned as Subject Matter Expert.

Confidential, Jul. 2004 - May 2009
Senior SQL Server DBA
Handled administration, database design, performance analysis, and production support, and was involved in migration of the Server SQL Server 2000 to 2005 and DTS to SSIS.
Fixed data issues, authored SQL scripts/procedures, and worked on a high availability environment like clustering, replication, database mirroring and log shipping.
Worked on snapshot/transactional replication, implemented DR processes, and worked on DTS, import/export utilities, BCP utility, and a replication tool.
Transferred packages using SSIS, created/modified stored procedures and functions, deployed reports, monitored/improved performance, and rebuilt indexes at regular intervals.
Managed the clustering environment, used log shipping for synchronization, created backups, developed procedures/functions, created constraints/indexes, and created views to restrict access for data security.
Conducted performance tuning, created reports, used SSRS, scheduled jobs/alerts, and migrated data from different sources, including flat files, MS Access, Oracle 8i/9i to SQL Server 2005, etc.

Confidential, Jan. 2000 - Jul. 2004
SQL Server DBA & Developer
Implemented MS SQL Server Management studio to create complex stored procedures using T-SQL to evaluate results for reports. Developed different scripts for Data Analysts for verification of reports.
Performed T-SQL tuning, optimized queries, conducted performance tuning of SQL 2000 servers, created SQL Server maintenance plans, and authored stored procedures and DTS packages.
Monitored and tuned databases, indexes, stored procedures, and server performance using performance monitoring tools for Microsoft SQL Server 2000.
Automated and enhanced daily administrative tasks, including space management, object alteration, backup and recovery, and performance monitoring.
Involved in entire life cycle including database design, development, testing, optimizing and deploying on development and production servers.
Wrote/tested program code, implemented programs, participated in creating indexes, and created constraints, defaults, and views.
Created logins, groups, users, roles, database devices, databases, mirroring devices, checked for database consistency, fixed DBCC errors, monitored error logs, database space allocations, transaction log space allocations, and fine tuning SQL performance.

Confidential, Nov. 1999 - Jan. 2000
SQL Server DBA
Implemented SQL logins, roles and authentication modes as part of security policies for various categories of users.
Created stored user-defined data types, procedures, triggers, and functions, as well as rebuilt indexes at regular intervals for better performance.
Designed and implemented comprehensive backup plan and disaster recovery strategies. Implemented and scheduled replication process for updating parallel servers.
Monitored performance, recovered databases, maintained databases, used log shipping, and analyzed/tuned long-running slow queries.
Analyzed various aspects of stored procedures and performed tuned as needed to increase productivity and reusability of code.
Provided DBA support for a development team customizing and testing new releases of client-server applications.
Handled up to half TB size databases with clustered and replication environment.

Education

Post-Graduate Diploma in Computer Science
Bachelor’s Degree in Computer Science

Certifications

MS SQL Server 2005 - Implementation & Maintenance
MS SQL Server 2005 - Business Intelligence Implementation & Maintenance
PRMS/LIMS/Track-Wise/Change Control/Citrix

Technical Skills

OS: Windows Server 2008R2/2008, 2003, 2000, NT.4.0. Windows 98/2000/ME/XP/XP/Professional/Vista/7, MS DOS
Databases: MS SQL Server 2008R2/2008/2005/2000/7.0, MS Office Access
Programming: SQL, TSQL
Applications: MS Office, MS Visio, MS Publisher, MS Project, SharePoint, DTS, MS SQL Server 2008/2005/2000/7.0
SQL Server: Management Studio, Business Intelligence Development Studio, Visual Studio 2005, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, SQL, T-SQL, DDL, DML, Stored Procedures, UDF, Triggers, OSQL, DTS, Log Shipping, Server Network Utility, Database Tuning Wizard, Index Tuning Wizard, SSIS, MS Clustering Services
Report Tools: MS Reporting Services (SSRS), Crystal reports
Data Migration: MS DTS, SSIS, BCP, Data Migration, SQL Loader, Import/Export Wizard
Other: ER-Win v 4.0, Visio 5.0, PL/SQL, Visual Source Safe, Net Backup, Compaq Insight Manager, Idera Diagnostic Manager, NetIQ, Quest Spotlight, SQL Light speed, ERWIN 4.0, Toad, SQL*Plus

Training