Sql Server Dba Resume Profile
SUMMARY:
- 10 plus years of MS SQL Server Core database administration experience development experience with DBA duties.
- Experience with Oracle 9i, 10g and 11g.
- Hands on Experience in installing, configuring, creating, managing, monitoring, and troubleshooting SQL Server 2000, 2005, 2008, 2008R2 and 2012 databases in both Physical and Virtual environments.
- Installed Cumulative Updates and service packs for various versions of SQL Servers.
- Upgraded to SQL Server 2000 and 2005 databases to higher versions 2008, 2008 R2 and 2012.
- Performed SQL Server database consolidations, upgrades, downgrades and migrations.
- Hands on experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
- Experience in Data transfer and Transformation using tools like DTS, BCP, Bulk Insert SSIS.
- Experience with establishing and maintaining security, integrity controls in conjunction with the applications and security groups and assist in the design and implementation of development, testing, QA, and production environments.
- Extensive experience with SQL Performance tuning and transaction analysis, thorough understanding of indices and statistics.
- Strong experience in database Backup, Restore and Recovery procedures.
- Hands on experience and knowledge of high availability SQL Server solutions, including Replication, SQL Server Clustering, Log Shipping Database Mirroring.
- Experience in using Performance Monitor/Profiler to resolve Dead Locks/Long running queries.
- Experience in Supporting Very Large Databases Troubleshooting the problems.
- Supported 60 plus dev, test, stage and prod database instances single handedly.
- Hands on experience on SQL Server 2005, 2008, 2008R2, 2012 Native and Sharepoint integrated mode Reporting Services.
- Experience with Sharepoint 2010 installation and management for SSRS.
- Configure and manage SQL Server Analysis Services SSAS 2005 and 2008R2.
- Familiarity with new features like Always-on in SQL 2012.
- Ability to work in a team environment with excellent communication, presentation, leadership, analytical, qualitative and interpersonal skills.
- Documented SQL server Configurations.
- Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team.
- Coordinated with Oracle teams on various administrative and development activities.
- Apply security updates/patches on Oracle Databases.
- Perform Oracle backups and recovery.
- Actively involved in the upgrade of oracle databases from 9i to 10g.
- Extensive experience with third party database maintenance tools like Embarcadero DBArtisan, Data Architect and Performance Center.
- Experience with Oracle Enterprise Manager Grid Control .
- Provided 24x7 support and involved in on-call rotation.
TECHNICAL SKILS:
Operating Systems: | Windows 98/2000/2003/2008, AIX, Linux |
Databases: | MS SQL Server 2000/2005/2008/2008R2/2012, Oracle 9i/10g/11g |
Languages: | TSQL, PLSQL |
Database Tools: | SQL Profiler, Performance Monitor, SQL Server Management Studio, DBArtisan, Performance Center, Data Architect |
ETL Tools: | DTS, BIDS, SSIS |
Reporting: | SSRS. |
EXPERIENCE:
Confidential
SQL Server DBA
Responsibilities:
- Install and maintain SQL Server 2008 R2 and 2012 database and SSRS on multiple servers.
- Implement Fannie Mae standard procedures on all the database instances.
- Monitor and troubleshoot database related issues and work with application teams to resolve issues.
- Migrate and upgrade databases from older versions to 2012.
- Lead a team that performed clustered database installations and managed clustered instances having Mount points.
- Actively involved in capacity planning.
- Provide On-Call support.
- Perform database backups and recovery.
- Provide Sharepoint backed database support with migrations and upgrades.
- Create, drop and alter database objects.
- Setup logins as per Fannie Mae standards and make sure security policies are strictly enforced in all the environments accordingly.
- Create and implement change and Incident tickets through the remedy.
- Provide application installation and setup support.
- Experience with tape backup retrievals.
- Create and update documentation.
- Monitor management reports
Environment: SQL Server 2005/2008/2008R2/2012 , SSIS, SSRS,WindowsNT/2000/XP/2003/2012
Confidential
SQL Server DBA
Responsibilities:
- Maintained various client databases in MS SQL Server 2000, 2005, 2008, 2008R2 and 2012 versions.
- Wrote stored procedures for ease of administration and management.
- Performance analysis and evaluation of queries and Databases in a slow running application and monitoring / optimizing / tuning the performance of the SQL Server.
- Scheduled maintenance on databases and capacity planning to increase performance and productivity.
- Administer client reports using Reporting Services SSRS in native and sharepoint integrated mode.
- Troubleshoot and minimize production down issues.
- Created and Implemented, scheduled maintenances and backup procedures to the database to enhance overall performance and disaster recovery methods.
- Extensive use of DTS/SSIS and scripting for various ETL processes.
- Maintained 60 plus database instances in dev, test, stage and prod.
- Upgraded SQL Server 2000 and 2005 databases to higher versions 2008R2 and 2012.
- Performed SQL Server database consolidations, migrations, upgrades and downgrades.
- Configured and Managed Standby databases using Log Shipping.
- Installed, configured and maintained SQL Server Clusters.
- Actively involved in capacity planning.
- Co-ordinated with Oracle team on various administrative and development activities.
- Apply security updates/patches on Oracle Databases.
- Perform Oracle backups and recovery.
- Installed Oracle clients.
- Actively involved in the upgrade of oracle databases from 9i to 10g.
Environment: SQL Server 2000/2005/2008/2008R2/2012, SSIS, Reporting Services, Replication, MS Access, OSQL, Windows NT/2000/XP/2003/2008, Oracle 9i/10g/11g , AIX, Linux, Embarcadero DBArtisan Performance Center
Confidential
SQL Server DBA
Responsibilities:
- Installation of MS SQL Server 2005.
- Installation of SQL Server Service Packs.
- Database designing and database modeling.
- Responsible for Database Backups Restoration, Backup Strategies and Maintenance Plans.
- Creating and moving databases and stored procedures for production from stage database and visa versa.
- Created Clustered and non-clustered Indexes.
- Creation of various data objects like tables, views and indexes.
- Cleansing databases by deleting unnecessary objects.
- Generated various reports using Reporting services.
- Involved in Security Administration- creating users and assigning them roles and privileges.
- Created Security Model for search criteria.
- Used SQL Server Integration Services SSIS to migrate DTS packages from SQL server 2000 to 2005.
- Configuring, Maintaining and Troubleshooting Database Mirroring.
Environment: Operating Systems: MS Windows Server 2003, MS Windows 2000 Professional RDBMS: MS SQL Server 2000 2005
Tools: SQL Server Business Intelligence Development Studio, SQL Server Management Studio, Enterprise Manager, Query Analyzer, System Monitor/Performance Monitor, Event Viewer, SQL Profiler, Index Tuning Wizard, Database Engine Tuning Advisor, Database Maintenance Plan Wizard, Data Transformation Services DTS SSIS
Front End: .NET FrameWork 2.0
Confidential
SQL Server DBA
Responsibilities:
- Installation of SQL Server 2000.
- Providing Primary DBA 24X7 support for databases in Stage and Production environment.
- Responsible for Database and Log Backups Restoration, Backup Strategies and Scheduling Backups.
- Created and Implemented, scheduled maintenances and backup procedures to the database to enhance overall performance and disaster recovery methods.
- Creating and moving databases and stored procedures for production from stage database.
- Performance analysis and evaluation of queries and Databases in a slow running application and monitoring / optimizing / tuning the performance of the SQL Server.
- Responsible to monitor 10 production servers and 6 development server individually.
- Worked with Various DBCC commands to ensure Database Consistencies.
- Creation of Clustered and non-clustered Indexes for Query Performance.
- Creation of various data objects like tables, views and indexes.
- Refreshing test databases whenever necessary.
- Generating various reports using complex stored procedures.
- Involved in Security Administration- creating users and assigning them roles and privileges.
- Scheduling Jobs and Alerting using SQL Server Agent.
- Using Data Transformation Services DTS an Extract, Transform Loading ETL tool for SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
- Configuring, Maintaining and Troubleshooting Replication.
- Creating Linked servers.
Environment:
- Operating Systems: MS Windows 2000server, MS Windows 2000 Professional RDBMS: MS SQL Server 2000
- Tools: Enterprise Manager, Query Analyzer, System Monitor/Performance Monitor, Event Viewer, SQL Profiler, Index Tuning Wizard, Database Maintenance Plan Wizard, Data Transformation Services DTS .
- Front End: VB 6.0/ VB. Net/ ASP. Net/ DotNetNuke Portal Technology
- Siebel Call center Event Management Module 7.5.3
Confidential
SQL Server Developer/DBA
Responsibilities:
- Installation of SQL Server 2000.
- Creatre Logins and setup security.
- Scheduling Jobs and Alerting using SQL Server Agent.
- Perform database Backups and restores.
- Performance Monitoring.
- Involved in Database Desingning and Modeling.
- Coded SQL to perform database tasks such as inserts, updates and deletes.
- Coded SQL to perform database tasks by using inner/Outer joins and group by/having clause.
- Created Database objects like Stores Procedures, Triggers, Views, and Rules etc.
Environment:
- Operating Systems: MS Windows 2000server, MS Windows 2000 Professional RDBMS: MS SQL Server 2000
- Tools: Enterprise Manager, Query Analyzer, System Monitor/Performance
- Monitor, Event Viewer, SQL Profiler, Index Tuning Wizard, Database Maintenance Plan Wizard, Data Transformation Services DTS .