OBJECTIVE

Having over 8 years of experience with solid back ground in analysis, design, development and implementation of software, hardware and network solutions for a variety of industries. My personal goal is to achieve high level of expertise across various branches of Information technologies: from data collection, transfer and storage to information security, analysis and representation that would allow me to design and build highly efficient, flexible, secure and reliable solutions.

PROFILE

• Having 8 years of IT experience out of 7years as Database Administrator with Microsoft SQL Server 2000\ 2005\ 2008\ 2008-R2.
• About 7 years of experience in System Analysis, Design, Data Modeling, Database Administration and Database Development.
• Experience with Production, Development, Staging & StressTest environments on Windows platforms.
• Over 5 years of Microsoft Business Intelligent suite (SSIS, SSRS) experience developing software involving full life cycle development and maintenance in various business applications on OLAP\OLTP systems.
• Creating and Administrating of all SQL Server Database Objects, Logins, Users and Permissions in each Registered Server. Manage Database Files, Transaction log, Estimate space requirements.
• Managing Ongoing activities like Importing and Exporting, Backup and Recovery.
• Expert in MS SQL Server activities like Installations, Upgrades, Configuring SQL Servers & Databases, Data Modeling, Implementing Data Integrity, Security, Database maintenance Plans, Data Migration, Data Transfer using BCP, SSIS\DTS, Database storage specifications and remote administration of the databases.
• 24 x 7 Production Database on call support.
• Installing and Administering SQL server in a clustered (High Availability) and standalone Environments.
• Experience in Database Mirroring, Log shipping and Replication in SQL 2000\2005\2008.
• Extensive experience in space allocation, database migration, database consolidation and server consolidation.
• Extensive experience in Capacity Planning, Disaster Recovery, Troubleshooting & Performance Tuning
• Manage and Maintain database changes in Development, QA, Staging and Production environments.
• Extensive experience in developing Stored Procedures, Triggers, Functions and Indexes etc.,
• Experience in day to day activities like Batch Processing, Import, Export, Backup, Restore, Database Monitoring tools, SQL jobs and Maintenance plans.
• Extensive experience in Installation, Configuration and Upgrading of Databases and Third party tools on Production, Development and Test Environments.
• Extensive experience in controlling the user Privileges, monitoring the Security and Audit issues.
• Strong communication, Time management skills and Ability to adapt quickly to changing environments.
• Good team player with excellent technical and interpersonal skills.
• Ability to work effectively and efficiently with limited supervision for oversight responsibilities with onsite and offsite development teams.

TOOLS & TECHNOLOGIES

RDBMS : SQL server 2000, SQL server 2005, SQL server 2008, SQL server 2008 R2.

Database Tools: SQL Enterprise Manager, SQL Query Analyzer, Import\Export wizard, Server
Network Utility, Client Network Utility, Service Manager.Business Intelligence
Tools: SQL Server 2005\2008 Integration Services (SSIS), SQL Server 2005\2008
Reporting Services (SSRS) and SQL Server 2005\2008 Analytical Services
(SSAS), SQL 2000 Data transformation services (DTS).

Bug Tracking Tools: SQL Profiler, Performance Monitor, Cluster Administrator, Varitas I3, AVICode,
Redgate.

Front-End Tools: MS Office/Project/Visio, BIDS, Visual Studio 2008,Visual studio 2010, BizTalk
2008, Fireworks, Flash, Cognos Reports, Erwin Datamodler, Model mart, TSM.

Languages: Visual Basic, C++, C, CGI-Perl, SQL/T-SQL, PL/SQL, Shell, ALP.

Scripting Languages: UNIX scripting, VBScript, SQL Scripting.

Technologies: Relational Modeling, Dimensional Modeling, Data Modeling, Data warehouse
modeling, OLTP, OLAP, ODBC, OLE-DB, CSS, XML, ASP, HTML, HTTP,
TCP/IP, FTP.

Administrative Tools: Active Directory, Microsoft Management Console, Synergy, Team Foundation
Server.

Operating System: Windows 2000/2003/2003 R2/2008, Windows XP, Windows 7.

PROFESSIONAL EXPERIENCE

Confidential NJ, USA Jun’08 – Till date Project Execution : Confidential USA
Team Size : 5
System : SQL server 2000\2005\2008\2008 R2
Position : Sr. Database Administrator \ SQL BI

• About Confidential
• Confidential is a full-service title, settlement, underwriting and vendor management services company serving real estate companies, affinity groups, corporations and financial institutions in support of residential and commercial real estate transactions having headquarters at Moorestown, New Jersey.
• Responsibilities:
• Responsible for managing and administering ITA’s SQL Server databases for its nation-wide distributed operations.
• Created SQL server stored procedures, functions, views, and tables to build ETL feeds and also created SSIS packages and SSRS reports to convert feeds into file Dashboards, Scorecards, Charts, and scheduled reports to end users in output text, excel, csv and PDF formats.
• Responsible for data modeling, database programming, and code review for application development and maintaining projects.
• Administering all MS SQL Server instances with in ITA and also with an external infrastructure hosting company. This includes various production environments as well as development and QA environments.
• Administering MS SQL servers remotely includes MS SQL Server installation, configuration, client/server connectivity, query optimization, back-up/recovery, Clustering, Replication, Log shipping, running Database Consistency Checks using DBCC and trouble shooting on large databases.
• Work with on-site and off-site development team through the full Software Development Life Cycle which includes Data model designing, Reverse engineering, forward engineering, generating schemas from data model, promoting database objects, code review for optimum performance, providing data base server metrics for SQA team.
• Responsible for trouble-shooting specific SQL Server bugs and errors, supporting all development efforts, and provide on-call support during off hours and weekends.
• Tested Procedures on the test database, modified the code for better performance and successfully implemented them on the production server.
• Ensuring that storage, archiving, back-up and recovery procedures are functioning correctly.
• Involved with System change control and Software development Life Cycle of various projects including post production support after deployment.
• Managing Database Users and Security for annual auditing.
• Configured and monitored database mirroring for mission-critical databases.
• Assisted application developers with database schema and procedure changes according to company conventions and best practices. Analyzed and approved
• database schema and procedure changes from dev to staging to production environments.
• Provide support in Tuning of Database Application, Stored procedures and Triggers. Replication to Synchronize data between servers.

Confidential NC, USA Nov’05 – May’08

Project Execution : Confidential, USA
Team Size : 4
System : SQL 2000\2005\2008
Position : IT Consultant - Database Administration

About Confidential

• Services provided by ITS Include IT services such as Application Development and Support, Project Management, Performance Monitoring and Reporting. It also provides Data Base Services as a core support for data base products such as MSSQL, Oracle, and DB2 for enterprise-wide applications.
• Responsibilities:
• Experience in database administration skills, including monitoring SQL health, backup/restore, and capacity planning.
• Develop databases and reporting mechanisms for Business users. This includes database management and design of DTS\SSIS packages, tables, stored procedures, SQL jobs, views, etc. in SQL Server 2000\2005\2008 environments. Projects include data import/export to/from flat files, Excel, Access, XML, etc. via DTS, FTP, and Bulk Loads. Modified existing reports and generated new reports based upon business user requests.
• Collaborated and consulted with clients, users, system administrators, and systems programmers to overcome significant operational and technical issues.
• Administer multiple server environments, including Development, Stress\Functional Testing, staging & Production.
• Involved in gathering client and user requirements regarding data usage.
• Generate SQL queries to support the company's data cleanup and/or auditing efforts.
• Develop stored procedures to support data management.
• Determine and design change management strategy and processes.
• Assist new application development teams in determining complex database requirements.
• Coordinate Microsoft Patch Management with security team for all servers.
• Maintain and document SQL Servers inventory and database change management procedures.
• Manage and maintain SQL replication, Logshipping, Database Mirroring and Database Snapshot.
• Troubleshoot and resolve SQL performance bottlenecks and hard ware issues.
• Document DBA best practices, database standards, and database security policy.
• Coordinate with software vendors and recommends a migration plan of the databases from SQL 2000 to SQL 2005.
• Participate in daily application support to provide customer service to resolve incidents and requests.
• Experience in high availability, standby, backup and recovery, large database management, and partitioning.
• Experience in database management, monitoring and tuning tools.
• Monitored helpdesk tickets to address all database and SSRS report requests.

Confidential CT, USA Oct’03 – Aug’05

Project Execution : Confidential CT, USA
Team Size : 8
System : SAP R/3 4.6B, Windows 2000, MSSQL, Oracle
Position : Full Time Database Consultant

About Confidential

Confidential is superior service and integrated end-to-end supply chain management solutions help customers turn their logistics challenges into a real competitive advantage. Kuehne Nagel deliver these services leveraging globally standardized, leading-edge information technology, ensuring synchronized display and control of each transport movement across the supply chain.

• Responsibilities:
• Monitor over 60 database servers and their databases for performance tuning, reviewing & tuning of complex SQL statements, Maintaining Backup and Recovery procedures performing database refreshes using TSM and Storage Subsystem tools.
• Written and updated advanced stored procedures for business reporting purposes.
• Data Extraction, Translation, and Loading using DTS\SSIS Packages. Data cleansing, and formatting as per the database requirements before loading. Packages have been scheduled to run automatically on daily/weekly basis. Setting up a test environment to make sure the accuracy of data.
• Worked with the process, training, and change leadership teams to design appropriate role-based security for the development, QA, and production environments including role definition and job/ position mapping.
• Creating, maintaining and optimizing database objects like indexes, triggers, views, stored procedures, catalogs etc.
• Performed Database Migration and consolidated databases, and SQL servers to reduce cost.
• Designed, Implemented and monitored transactional replication and Log shipping.
• 24\7 rotating roster on call production support.
• Created Vendor Performance Reports that lists Vendor Name, Materials Supplied, Planned & Actual Delivery Times, Payments Terms and Prices.

Confidential India July’02 – Aug’03

Project Execution : Confidential, Hyderabad, India
Team Size : 13
System : Cisco VPN Concentrators, Nortel Contivity Switches, RSA ACE
Server 6.0, Cisco Secure ACS.
Position : Associate Network Engineer

About Confidential

Confidential predominantly provides IT personnel staffing services in systems integration and professional services; enterprise application development and management; application software for the financial services industry; business process outsourcing; managed hosting services; and application and IT infrastructure outsourcing.

Responsibilities:

• Configuration, administration and management of Cisco VPN concentrators and Nortel Contivity switches.
• Troubleshoot IPSEC related connectivity issues for remote access VPN.
• Configuration and management of Cisco Secure ACS for Fiber link/dialup users with RADIUS/

TACACS+protocol.

• Troubleshoot dialup/Fiber link/VPN connectivity related issues on daily basis with 99% SLA

Achievement:

• Configuration of RSA ACE Server 6.0 for user authentication and authorization services.
• Administration and management of local/remote users on RSA ACE server for nearly 30 clients and

CSC internal.

• Implement cross-realm ACE server authentication for remote users.
• Generate various usage reports from RSA ACE server.
• Troubleshoot RSA hardware secure ID issues with appropriate logging.
• Troubleshoot RSA software secure ID issues both at user and server end.
• Participate on call with customer for regular troubleshooting.
• Participate in service restoration activities during any critical service outage and bring it to resolution.
• Responsible to create processes for new requirements.
• As Quality representative of the team, responsible for managing QMS (Quality Management System)

EDUCATION