We provide IT Staff Augmentation Services!

Sql Dba Resume

SUMMARY

  • SQL Server DBA with experience in project management, people management, solution development, system integration roles in a career spanning 15 years, giving a well - rounded experience on various customer scenarios.
  • Experience in SQL database administration on production, staging & development servers with server configuration, performance tuning, and maintenance with excellent troubleshooting capabilities.
  • Experience in Disaster Recovery Planning, SQL Server Replication, Backup/Recovery and Security Management operations. Having hands on experience in DR processes including Log Shipping and Database Mirroring.
  • Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
  • Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Standards.
  • Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
  • Extensive experience in Installation, Configuration and Deployment of SSRS using ScaleOut, ScaleUp and Local topologies.
  • Create, manage SQL Server AZURE Databases. Setting up SQL Azure Firewall. Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio (SSMS) for Developers.
  • Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
  • A multidimensional profile with Six Sigma Green Belt, capable and experienced in handling Database Administration, project, people and solutions management.

PROFESSIONAL EXPERIENCE

Confidential

SQL DBA

Responsibilities:

  • Migrating database to RDS instance.
  • Setting up Connection Strings and connecting to SQL Server RDS instances from locally Installed SQL Server Management Studio (SSMS) for Developers.
  • Querying servers for getting details of users/logins.
  • Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
  • Performed Production support and on Call duties.
  • Developed, deployed and monitored SSIS Packages for new ETL Processes.
  • Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.

Confidential

SQL DBA

Responsibilities:

  • Configure trace to identify users/logins accessing orphan/unmapped servers.
  • Responsible for all SQL Server General Administration and Performance.
  • Setup backup and restoration jobs for development and QA environments.
  • Performed installation of SQL Server & Service Packs.
  • Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
  • Migrated SQL server 2000 to SQL Server 2008R2/2012.
  • Migration of DTS packages to SSIS packages.

Confidential

SQL DBA.

Responsibilities:

  • Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
  • Ensure all the SQL SERVER features worked as expected after consolidation or fail over.
  • Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
  • Help the developers & testers understand & debug issues related to SQL Server.
  • Security and architectural planning issues met as well as testing and training.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Used DBCC checks to ensure the physical consistency of the database and objects post failover & consolidation.
  • Providing support to the Application developers on the application databases.
  • Performed Production support and on Call duties.

Confidential

Lead Developer

Responsibilities:

  • Worked with various business groups while developing their applications, assisting in database design, installing SQL Server clients, phasing from development to QA and to Production environment.
  • Stellar role in implementation of Speciality Liability certificate project resulting in online & almost intervention free issuance of Speciality coverage. This was a Six Sigma Green belt project.
  • Successfully ported Schindler’s Mobilinx application from the current Windows NT 3.51 based Symbol devices to Intermac's 700 Pocket PC based devices. The application was ported from VB4/Access 2 to VBCE/SQLCE platform.
  • Preparing & presenting the monthly SLA review to GE App Lead.

Hire Now