We provide IT Staff Augmentation Services!

Sql Dba Resume

El Segundo, CA

Professional Summary:

  • Around 7+ years of SQL Server DBA experience in IT, Commercial, Banking, Health and Finance environments
  • Experience in an operational environment providing support involving coordination with release management and change management.
  • Experience with SQL Server 2000, SQL Server 2005, SQL Server 2008 installation, administration and management of multiple instances/servers in highly transactional environments
  • Extensively worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.
  • Experience in Migration from SQL Server 2000 to SQL Server 2005 and SQL server 2008 as well as DTS Xchange tool for migrating DTS packages to SSIS packages
  • Worked with IT staff on various projects like Server upgrades, Data center migrations etc.
  • Expert in Disaster Recovery Planning with Log shipping, replication etc. and High Availability solutions like DB Mirroring, Clustering etc.
  • Worked with Developers for query optimizations, performance tuning, package deployments, code changes etc.
  • Proficient with database backup/restore, backup compression, recovery procedures, index maintenance, production security standards, change requests , partioning etc.
  • Proficient with SQL Enterprise Manager, SQL Query Analyzer, SSMS, BI studio , SQL Profiler, Database Tuning Advisor, DMVs
  • Extensive experience with data modeling, Dimensional modeling, logical and physical database design.
  • Excellent T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands Experience in Replication – Snapshot, Merge and Transactional. Experience in Change Data Capture (Cdc) to track important tables for clients
  • Experience in using different Transformation tools like DTS packages, BCP, and BULKINSERT, SSIS.
  • Education & Certification:

  • Bachelor of Engineering- Electronics and Communication
  • Technical skills

    RDBMS:

    MS SQL SERVER 2000/2005/2008, Analysis Server 2000/2005, Ms Access 2000/2005

    Databases Tools:

    SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIS), Database Engine Tuning Advisor, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, DTS xChange , Veritas
    MS Visio, DB artisan, SQL reporting, SSIS, SSAS

    Programming Languages:

    SQL, TSQL, XML, PL/SQL.,Java/JSP,C++/C# , .NET

    Web Tools:

    MS-Front Page, Internet Information Server(IIS),FTP,TCP/IP,LAN,MS-Outlook Express

    Operating Systems:

    Windows 95/98/2000/2003/2008/XP/NT 4.0, Unix, Linux, MS-DOS.

    Utility Tools:

    MS Office, MS Project, ClearQuest, Visual Source Safe 6.0, Rational ClearCase

    Professional Experience

    Client: Confidential,El Segundo ,CA Mar’11 –Present
    Role: SQL DBA

    Confidential, is the market and technology leader in on-demand workforce management for the public sector. Confidential,products automate the entire hiring and performance evaluation process, including position requisition approval, automatic minimum qualification screening, test statistics and analysis, and EEO reporting

    Responsibilities:

  • Involved in installing and configuring of SQL Server 2008.
  • Installed SQL 2008 standard edition with SP1 for testing present application and migrating test databases to test any upgrade issues.
  • Involved in Data modeling, designing and building relational databases using Erwin tool.
  • Implemented Database Mirroring between primary server and a standby server.
  • Running DBCC consistency checks, and fixing data corruption in user databases.
  • Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
  • Creating databases and logins with permissions in SQL server 2008 as per the developer’s request.
  • Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
  • Prepare daily report on the job failures, backup failures and disk space and implemented a e-mail notification solution to be notified when a threshold or error is encountered.
  • Involved in resolving dead lock issues and performance issues.
  • Created and scheduled jobs to setup log shipping between production servers as well as standby servers.
  • Used SQL Assistant for writing advance SQL queries, and used xSQL data compare to compare databases and tables for sync between dev, test and production.
  • Coordinating with the development team regarding tuning the SQL queries and stored procedures.
  • Identifying the bottlenecks and troubleshooting it for optimal performance.
  • Responsible for MS SQL Server 2008, configuration, tuning and provide support to all Production and development servers.
  • Performed all aspects of database administration, including data modeling, backups andrecovery.
  • Configured Transactional replication between Primary Server and three Read–Only servers, with separate Distributor server and experience in troubleshooting replication problems.
  • Successfully Migrated SQL 2000 DTS packages to SSIS using DTS Xchange tool.
  • Additionally, designed and implemented a disaster recovery system.
  • Running Index tuning wizard and rebuilding indexes for faster query response.
  • Created the logical and physical data modeling using Erwin tool.
  • Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
  • Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL Accounts).
  • Created documentation to install SQL Server, apply service pack, hot fix and clustering installation.
  • Expertise in Security Issues such as creation and granting permissions on various Objects.
  • Prepared the reports for the day-to-day as well as weekly/monthly purposes.
  • Environment:
    MS SQL Server 2005/2008, Windows 2000/2003 servers, Active Directory , IIS Web server, DTS, SQL Upgrade Advisor, MS Access, Microsoft Analysis Services, Diagnostic Manager, Microsoft Reporting Services, UNIX, Powershell, Microsoft SQL Server Integration Services(SSIS), Litespeed


    Client: Confidential,Culver, CA Jan’10-Mar’11
    Role: SQL DBA

    Confidential,is a human powered search engine and results are generated non-algorithmically by a team of profile builders who create pages for search terms . Mahalo includes the most appropriate hand found links and information about for about 10000 unique queries.

    Responsibilities:

  • Responsible for MS SQL Server 2005, configuration, tuning and provide 24 X 7 dedicated support to all Production, development and clustered servers.
  • Involved in Data Migration from SQL 2005 to SQL 2008.
  • Performed all aspects of database administration, including data modeling, backups andrecovery.
  • Configured Transactional replication between Primary Server and three Read–Only servers, with separate Distributor server and experience in troubleshooting replication problems.
  • Resolved the SQL Server 2005 upgrade hurdles and successfully Migrated SQL 2000 DTS packages to SSIS using Upgrade advisor and Package Migration wizard.
  • For complex packages like password protected packages, packages created using SQL Native client used DTS Xchange tool.
  • Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like oracle. Design new SSIS packages as per needs, Resolve the problems.
  • Generated different types of Reports (Tabular/Matrix) using MS SQL Server Reporting Service (SSRS).
  • Designing and Optimizing all the SSIS packages
  • Incorporating business logic in SSIS packages while converting from Oracle, MS Access and Text to SQL Server. Creating new database/tables to put in the extracted data and rebuilding the relationship.
  • Additionally, designed and implemented a disaster recovery system.
  • Running Index tuning wizard and rebuilding indexes for faster query response.
  • Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL Accounts).
  • Prepared Estimates for Database, table size growth.
  • Created documentation to install SQL Server, apply service pack, hot fix and clustering installation.
  • Expertise in Security Issues such as creation and granting permissions on various Objects.
  • Prepared the reports for the day-to-day as well as weekly/monthly purposes.
  • Wrote and integrated Stored Procedures to generate the Reports.
  • Environment:
    Windows 2003 Server, SQL 2005 / 2008 Enterprise Edition, Oracle 10g,SSRS, SSAS, SSIS, Performance Point Sever 2007,T-SQL, ASP.NET2.0, C#.NET, ADO.NET, Microsoft Visual Studio.Net 2005, .NET Framework 2.0, EXCEL2007.

    Client: Confidential,Carlstadt, NJ Oct’08 - Dec’09
    Role: SQL Server DBA

    Confidential,provides domestic and international courier, mail and hand delivery devices for business clients across the United States and Canada. It provides both time-definite and non-time critical, business-to-business delivery services. Their customers range from Fortune 500 to smaller companies.
    Responsibilities:

  • Involved in installing and configuring of SQL Server 2000 and 2005, both in unattended and remote installations.
  • Involved in Data modeling, designing and building relational databases.
  • Transferred data from Oracle to SQL server using SSIS.
  • Implemented Database Mirroring.
  • Running DBCC consistency checks, and fixing data corruption in user databases.
  • Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
  • Creating databases and logins with permissions in SQL server 2005 as per the developer’s request.
  • Created Linked Servers between SQL server 2000/2005 and Oracle servers in the environment.
  • Involved in migrating the backup jobs from SQLserver to Lite Speed
  • Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
  • Prepare daily report on the job failures, backup failures and disk space.
  • Involved in resolving dead lock issues and performance issues.
  • Created and scheduled jobs to setup log shipping between production servers as well as standby servers.
  • Documentation of daily tasks and scripting them using DBScribe.
  • Very good hands on experience with DBArtisan admin tool as well as VERITAS Netbackup.
  • Coordinating with the development team regarding tuning the SQL queries and stored procedures.
  • Identifying the bottlenecks and troubleshooting it for optimal performance.
  • Responsible for MS SQL Server 2000, configuration, tuning and provide 24 X 7 dedicated support to all Production, development and clustered servers.
  • Performed all aspects of database administration, including data modeling, backups andrecovery.
  • Configured Transactional replication between Primary Server and three Read–Only servers, with separate Distributor server and experience in troubleshooting replication problems.
  • Resolved the SQL Server 2005 upgrade hurdles and successfully Migrated SQL 2000 DTS packages to SSIS using Upgrade advisor and Package Migration wizard.
  • For complex packages like password protected packages, packages created using SQL Native client used DTS Xchange tool.
  • Additionally, designed and implemented a disaster recovery system.
  • Running Index tuning wizard and rebuilding indexes for faster query response.
  • Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL Accounts).
  • Prepared Estimates for Database, table size growth.
  • Created documentation to install SQL Server, apply service pack, hot fix and clustering installation.
  • Expertise in Security Issues such as creation and granting permissions on various Objects.
  • Prepared the reports for the day-to-day as well as weekly/monthly purposes.
  • Wrote and integrated Stored Procedures to generate the Reports.
  • Environment: Microsoft SQL Server 2005, SQL Server Management Studio, Business Intelligence Development Studio, SQL Server Integration Services (SSIS), SSRS, SSAS, Crystal Report v9.0, VB.Net, Windows XP, Office 2003.
    Avea Confidential,Istanbul, TURKEY Jun’05-Apr’08


    Role: DBA

    Confidential,the youngest operator of Turkey, has a nationwide customer base of 12.8 million as of the first quarter of 2012. Offering services to 98% of Turkey\'s population through its next generation network, the company is growing fast both in the corporate and individual services with the brand "Avea"
    Responsibilities:

  • Actively involved in creation of database, modified tables, triggers, and store procedures to clean and validate the data to meet the company specifications.
  • Created database objects like tables, stored procedures, views, Triggers, Rules, Defaults, User defined data types and functions in SQL Server 2005.
  • Made enhancements and developed stored procedures as per the requirements.
  • Installed and configured MS SQL Server 2005. Edited the server registration properties, Created Logins. Managed the object level permissions and security issues of the server.
  • Created Backups Strategies for databases and automated the process.
  • Provided support for Clustering environment, DTS packages and Transactional/Merge replication.
  • Created Transactional replication, pull subscription and defined edition to transfer data from branch to head office and vice versa.
  • Implemented a Customer Records Management system using SharePoint Portal Server.
  • Written stored procedures for automatic scripting to backup transaction logs, log file, maintain archive of objects and so on.
  • Replicated SQL servers handling thousands of logins per day with 24/7 uptime to service clients.
  • Involved in Management of clustered database servers.
  • Ensured constraints and writing triggers to apply business rules. Performance Tuning, backing up and restoring user databases.
  • Involved in Designing and Implementation of data warehousing solution which includes Building an OLAP database, creating data source.
  • Extracted data from SQL Server for report, backup, testing purpose by using SSIS
  • Managed databases on multiple disks using RAID technology.
  • Created different user level groups and assigned appropriate permission level to the database. This made sure that only right person with enough authority would be able to see the information.
  • Created distributed partitioned views, debugging / troubleshooting stored procedures, upgrading existing ones.
  • Hire Now