We provide IT Staff Augmentation Services!

Sr. Data Base Administrator Resume

Irving, TX

SUMMARY

  • Over 7+ years experience in Database Administration, System Analysis and Administration, Design, Development & Support of MS SQL Server 2008, 2005, 2000, and 7.0 in Production, Development & Replication Environments.
  • Extensive experience in installation, configuration, and maintenance of MS SQL Server 2008/2005/2000.
  • Expert in Table Normalization, Optimization and Tuning, Data Import/Export, Troubleshooting, Database Objects authorization, , Objects Creation such as Tables, Views, User created Data Types, Indexes, Stored Procedures, Cursors, Triggers and more.
  • Good experience in Upgrading and migrating from SQL server 7.0 to SQL server 2000/2005/2008
  • Experienced in working with production 24/7 Environment
  • Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
  • Extensive experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models and data integrity.
  • Expert in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous Systems using SQL Server tools like SSIS, DTS, Bulk Insert, BCP and XML.
  • Expert in of various source transformations, including flat files, XML and relational systems.
  • Experience in Extraction Transformations and Loading (ETL) tools like SQL Server Integration Services(SSIS),Data Transformation Services (DTS), Bulk Insert, and Bulk Copy ( BCP)
  • Experienced in implementing log shipping.
  • Experienced in implementing database mirroring.
  • Expert level skills in Clustering, Replication, Data Modeling (Physical and Logical), Server Mapping, Installation and Configuration, up gradation form previous versions.
  • Created maintenance plans to perform index defragmentation, re-indexing and update the index statistics.
  • Proficient in troubleshooting database issues.
  • Experience in Creating Roles and managing user permissions, Jobs, Alerts, SQL Mail Agent, and using performance monitor/profiler for resolving deadlocks.
  • Experienced in Design, Development, Testing, Implementation and production, support SDLC of Client/Server, and Web based applications
  • Good experience with SQL Server 2005 Online Database Indexing and Recovery.
  • Have knowledge in ADABAS database management system.
  • Excellent Knowledge in analyzing Data ware house by building cubes using SQL Server Analysis Services (SSAS).
  • Excellent Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server 2005 Reporting Services (SSRS).
  • Expert in generating reports like matrix parameterized and drill through reports using SSRS and developed stored procedures using functions to generate various kinds of reports using SSRS.
  • Expert in designing report layouts in SSRS and deployed cubes using SSAS.
  • Creative and aggressive self-starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments and strong written and verbal communication skills.

TECHNICAL SKILS

Microsoft SQL Server 7.0/ 2000/2005/2008 , Windows 95/98/NT/XP/ 2000/2003/2008 Advanced Server, Windows Exchange Server 2003/2007, Team Foundation Server (TFS) 2008/2010, My SQL, MS-Access, SQL, T-SQL, ASP.NET, XML,MS Visual Studio 2005/2008, SSRS, SSIS, SSAS, DTS, SQL Profiler, Power Builder, Management Studio, ERWIN, MS Visio 2005/2008.

PROFESSIONAL EXPERIENCE

Confidential , Schaumburg, IL

Sr. Data Base Administrator.

Confidential 's Mobility Suite is a robust set of software products that address the most significant and costly challenges associated with enterprise mobility solutions - deployment, optimization, management, and protection throughout the entire lifecycle of your mobility solution. Confidential provides telephone-based customer relationship management services, typically for big companies. Confidential ’s one of most generating of its revenue from its business-to-consumer unit, which specializes in handling inbound sales orders, service requests, and customer questions and complaints. Primary responsibilities involved maintaining member records within each client database, creating the SSIS packages.

Responsibilities:

  • Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.
  • Planned and modified the permission issues in the server.
  • Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
  • Fine tuning the Database Settings as well as the Server Settings.
  • Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.
  • Creating, maintaining the users, roles and granting privileges.
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, Joins and other T-SQL code to implement business rules
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, Joins and other T-SQL code to implement business rules
  • Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.
  • Planned and modified the permission issues in the server.
  • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services.
  • ETL implementation using SQL Server Integration Services (SSIS).
  • Developing reports on SSRS on SQL Server (2008).
  • SQL Server 2005/2008 OLAP database development working with slow changing dimensions.
  • ETL implementation using SQL Server Integration Services (SSIS).

Environment: Microsoft SQL Server 2005/2008, MS Windows Server 2003/2008, SSAS, SSIS, SSRS, Visual Studio 2008, ASP.NET, T-SQL, XML, SQL, PL/SQL, DDL/DML, Windows 2003/08 Server, AIX, I-series

Confidential, Irving, TX

Sr. Data Base Administrator

Confidential is a online retail store based on e-commerce technology. Confidential carries wide verity of products including from ladies gadgets to house hold item. Project was based on to link up all servers data base and linked with all stores as result any online booking of any product should send by nearby stores. It also includes providing sales report to company and maintain the servers alive.

Responsibilities:

  • Involved in creating tables, views, indexes, cursors and stored procedures.
  • Involved in creating data models and designing logical and physical models of database.
  • Designing and validating the forms according to client requirement by using VB.
  • Involved in designing the system models using UML and ER Diagram.
  • Wrote SQL scripts to Insert, Update and Delete data in MS SQL database.
  • Created schemas, views, stored procedures, Triggers and functions for Data Migration. Involved in the complete life cycle of the project, from Planning Staging and pushing the codes to production.
  • For CRM, tune the store procedure, for reduce the response time.
  • Administrate SQL Server cluster Environments (2000,05,08), Jobs, backups, Tuning, indexing, Tracing, auditing, setup and configuration.
  • Created backup recovery plans and managed backup and restoration procedures.
  • Writing SSRS reports and SSIS packages, work with the team to build an OLAP cube using SSAS 2008
  • Support co-workers and provide technical advice
  • Defined Check constraints, Business Rules, Indexes, and Views.
  • Regularly monitored the system for bottlenecks and suggested/implemented solutions.
  • Provided on call support and remotely supported the branch offices with periodic analyzing of the database.
  • Very good experience in the maintaining production servers, monitoring performance issues, trouble shooting and solving production issues.
  • Implemented disaster recovery for SQL Server Production Database as Fail-Over or Standby servers.
  • Used Log Shipping Technique for warm backup solution for MS SQL Server databases.
  • Experience in planning and implementing the Replication of MS SQL Server 2000 and 2005 Databases and replication databases Backup recovery strategy.
  • Creation and maintenance of Users security permissions and Migration the entire database objects from one server to another server and database to another database.
  • Maintain and troubleshoot Replication issues by continuous monitoring of replication.
  • Checked Performance Tuning, Indexing, Query Optimization.
  • Provide network documentation, training, and guidance to computing system clients and users.
  • Establish user profiles, user environments, directories, and security for networks being installed.
  • Determine source of computer problems (hardware, software, user access, etc.).
  • Document computer problems and resolutions for future reference.

Environment: SQL Server 2000/2005/2008 , Db2, Stored Procedures, SSRS, SSIS, SSAS, ETL, T-SQL, PL/SQL, DDL/DML, Windows 2003/08 Server, AIX, I-series

Confidential, Des Moines, IA

Data Base Administrator

Responsibilities:

  • Creation of user Databases and installation
  • Involved in Installing, Configuring and Maintenance of SQL Server 2000 and 2005.
  • Installation of Microsoft SQL Server 2000 on New Production and Test servers with latest Security updates involving Service Packs and Security patches.
  • Data Migration between SQL Servers 2000 and 2005
  • Monitoring SQL server, Application logs and analyzing the logs.
  • Maintaining both Dev and Production servers in sync.
  • Creating users with Windows or SQL Authentication and assigning permissions.
  • Perform Full and Transaction Log Backups. Restore them whenever necessary; creating back up strategies and scheduling them for execution.
  • Documented Disaster Recovery Plans and participated in disaster recovery.
  • Maintenance and Correction of Transact Sequel Server (T-SQL) Statements
  • Documented Disaster Recovery Plans and participated in disaster recovery.
  • Working with various departments while developing their applications, assisting in Database design, phasing from development to QA and to Production environment.
  • Maintain and troubleshoot Replication issues between SQL 2000 and 2005 by continuous monitoring of replication.
  • Resolving various performance issues and running DBCC commands, SQL Tracer, SQL Profiler and NT monitoring tools.
  • Created DTS Packages for executing required tasks. Created the Jobs and scheduled for daily running.
  • SQL Server Integration Services (SSIS)
  • Involved in Performance Tuning for Source Databases, and Target Databases. Documentation of Maintenance Plans.
  • Daily Monitoring of the Database Performance and network issues.
  • Rebuilding Indexes on various tables.
  • Database Full and Log Backups & Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
  • Work as a team member with other technical staff, such as systems to ensure connectivity and compatibility between systems.
  • Document network problems and resolutions for future reference.

Environment: MS SQL Server 2000/7.0, Windows 2000, MS Office 2000, Stored Procedures, SSRS, SSIS, SSAS, ETL, T-SQL,

Confidential, Raleigh, NC

Data Base Administrator

Confidential is one of the largest family- controlled financial institutions in the country. It does its business based on individual clients needs and providing sound financial advice to its customers.
Confidential automated to optimize business processes and provide staff with access to all relevant content for each case at every step regardless of content source. The project was to load the data from various sources (branches of First Citizen Bank) into a single Data warehouse by the help of BCP. Generate customized reports from the database based on the requirements.

Responsibilities:

  • Actively involved in analyzing the old database system and mapping tables, relationships, columns to SQL Server 2000.
  • Efficiently worked in installation, configuration, design, implementation of staging database for data migration and data entry.
  • Developed SQL scripts to Insert, Update and Delete data in MSSQL database tables in OLTP environment.
  • Involved in performing extraction, transformation and loading using DTS.
  • Handled database objects with Enterprise Manager and Query Analyzer.
  • Designed, developed and deployed complex DTS packages to cleanse and transform data and load from legacy systems into the Enterprise system SQL Server database.
  • Used advance features of T-SQL to design and tune T-SQL to interface with the databases and other applications in the most efficient manner.
  • Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.
  • Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard.
  • Designed and implemented Job scheduling, setting up alerts, User logins and access rights based on user roles, permissions and security requirements.
  • Created Reports using SQL Server 2000 Reporting Services using Microsoft Visual Studio.
  • Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
  • Built the report models, created a wide variety of interactive reports for business users in SSRS and deployed the reports in various formats depending on the user requirements.
  • Used query analyzer and optimizer to optimize queries
  • Wrote and Optimized Triggers and Queries in T-SQL.

Environment: SQL Server 2000/2005, Stored Procedures, SSRS, SSIS, SSAS, ETL, T-SQL, PL/SQL, DDL/DML, Windows 2003 Server, AIX, I-series

Confidential

MS-SQL Server Developer

Confidential is India’s second largest bank with total assets of $81 billion and making good profits. Confidential offers a wide range of banking products and financial services to corporate and retails customers through a variety of delivery channels and through its specialized subsidiaries in the areas of investment banking, life insurance, venture capital and capital management. The project was to load the data from various sources (branches of ICICI) into a single Data warehouse by the help of BCP. Generate customized reports from the database based on the requirements.

Responsibilities:

  • Carried out a Developer’s role on MS SQL Server 2000, MS Access Databases (using DTS, Stored Procedures and Views).
  • Involved in developing the SQL code for the application.
  • Experience in database design using E R modeling tools.
  • Involved in design and implementation of the Stored Procedures and Triggers for automating tasks.
  • Created Tables, Stored Procedures, Views, Constraints and User Defined Functions.
  • Created/modified complex store procedures to fit to the changing requirements and to enhance performance and developed custom functions, indexes to ensure accuracy, quality and consistency of the database.
  • Wrote and Optimized Triggers and Queries in T-SQL.
  • Created and managed database users, login Ids and security.
  • Wrote T-SQL queries with the help of Stored Procedures, Functions, Triggers, Cursors, Views, and Indexes.
  • Responsible for performing complete back up and restoration, database maintenance
    Service pack updates on server and client.
  • Created various kinds of reports like drill down, drill through and on demand sub reports in Crystal reports 9.
  • Customized reports by adding new features such as report alerts, cross-tabs, running total, sub-reports and drill-down fields.

Environments: MS SQL Server 2000, T-SQL, Query Analyzer, Outlook, DTS, BCP,HTML, Enterprise Manager, OLTP,OLAP,MS-Excel, SQL Loader, Crystal reports 9.

Hire Now