We provide IT Staff Augmentation Services!

Sql Database Administrator/dba Resume

SUMMARY

  • Experienced hands - on professional experience in SQL Server database as a DBA
  • Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication, Alwayson
  • Experience in troubleshooting and resolving frequent database issues including integrity issues, replication, log shipping, mirroring, connectivity, and security related issues etc
  • Experienced in installing and configuring SQL Server, applying patches and fixes
  • Strong knowledge in setting up and managing database security by creating new users, roles, profiles, and provide required user privileges in development, test, training and production environments
  • Experience monitoring, troubleshooting and performance optimization related issues
  • Extensive experience in using DTS, SSIS, BCP to import data from different sources of data into SQL Server Databases
  • Knowledge in Configuring SQL Server Agent, create, maintain and monitor jobs
  • Knowledge of Power Shell and T-SQL scripting.
  • Have excellent analytical, problem solving, communication and interpersonal skills with ability to interact with people at all levels and can work as part of a team or independently
  • Devoted and Quick learner with capability to master and implement new technologies
  • Excellent presentation and documentation skills
  • PL1 programing Language
  • Excellent experience on Adabas Natural.

TECHNICAL SKILLS

Databases: Microsoft SQL Server 2000/2005/2008/2012 , MS Access, BD3

Tools: SSMS, SSIS, SSRR, on SQL Server

Operating System: Windows server 2000, windows server 2003, windows server 2008 and Vista/windows 7, Windows /98/2000

Web server: MS Internet Information Server (IIS)

PROFESSIONAL EXPERIENCE

Confidential

SQL Database Administrator/DBA

Responsibilities:

  • Major duties: Installed and Configure SQL Server 2000, and 2005 in test and production environment.
  • Migrated databases from SQL Server 2000 to 2005 in test and production environment.
  • Migrated MS Access 2003 databases into SQL Server 2000.
  • Closely worked with business analyst to collect requirements & make systems available ASAP.
  • Rebuild Servers (Restore & Recovered from tape/CD backup) from backup.
  • Configured Log Shipping from Production to Standby Server (Running as Reporting Server).
  • Configured and Maintained Replications (Transactional).
  • Writing T-SQL and/or. PowerShell Scripting and Stored-Procedures.
  • Performed Database, SQL, and index tuning.
  • Assisted SQL developers to optimize SQL queries and Stored Procedures.
  • Grant internal/external developers to development servers, shares.
  • Created Backup strategy for production and development environment.
  • Database Backup & Restore.
  • Scheduled jobs.
  • Setup and configure Database mail for notification purposes.
  • Developed Database Maintenance Plan.
  • Monitor Servers activity, solving problem.
  • Monitor and resolve Mantis bug tracker for client issues. Troubleshooting connectivity issues Permissions, etc with custom applications and SQL.
  • SQL Server Error Log, space usage.
  • Run DBCC statements to check physical and logical consistency of the database and Rebuild indexes.
  • Export & Import data from Oracle, MySQL, and Access Database including flat files like text, excel, and CSV files into SQL Server databases..
  • Designed Logical & Physical Database
  • Involved in creating and modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers.
  • Used DBCC to check physical and logical consistency of database and Rebuilding indexes.
  • Database Monitoring - Used Clever Path Dashboard to monitor and diagnose different problems.

Environment: MS SQL Server 2008/2005/2000 , Windows 2000 Advanced Server, and Windows Server 2003 Enterprise Edition

Jr. SQL Database Administrator/DBA

Confidential

Responsibilities:

  • Major duties: Installed and Configure SQL Server 2000, and 2005 in test and production environment.
  • Migrated databases from SQL Server 2000 to 2005 in test and production environment.
  • Migrated MS Access 2003 databases into SQL Server 2000.
  • Closely worked with business analyst to collect requirements & make systems available ASAP.
  • Rebuild Servers (Restore & Recovered from tape/CD backup) from backup.
  • Configured Log Shipping from Production to Standby Server (Running as Reporting Server).
  • Configured and Maintained Replications (Transactional).
  • Writing T-SQL and/or. PowerShell Scripting and Stored-Procedures.
  • Created Backup strategy for production and development environment.
  • Database Backup & Restore.
  • Monitor and resolve Mantis bug tracker for client issues. Troubleshooting connectivity issues Permissions, etc with custom applications and SQL.
  • SQL Server Error Log, space usage.
  • Run DBCC statements to check physical and logical consistency of the database and Rebuild indexes.
  • Designed Logical & Physical Database
  • Involved in creating and modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers..

Environment: MS SQL Server 2005/2000, Windows 2000 Advanced Server, and Windows Server 2003 Enterprise Edition

Sales Data Analyst

Confidential

Responsibilities:

  • Use in-house and PAX-is data and analyze it to track the distribution channels activity and introduce appropriate sales strategy.
  • Support the development and analysis of measurable components of data collection activities, apply techniques to data management, quality assurance, and explore best approaches to data analysis and reporting.
  • Maintains and monitors records and reports of frequent fliers, travel agencies & travel related agencies & any relevant organizations.
  • Analyzes the effectiveness of sales, methods, costs, and results.

Hire Now