We provide IT Staff Augmentation Services!

Sr Sql Server Dba Resume

WashingtoN

SUMMARY

  • 6 years of experience as SQL Server Database Administrator and enterprise information technology operations
  • 5 years of experience as SQL Developer
  • Experience working in hybrid environment, deploying and managing SQL Server databases
  • Experience in planning and configuring windows server failover cluster, designing and implementing high availability/disaster recovery applications using various SQL Server features including Always On availability groups
  • Installed and configured multiple virtual machines on Azure and Managing about 200 SQL server databases, Performed Migration of SQL server instances and databases in hybrid environment
  • Experience in Windows Server Infrastructure, SQL Server installation, administration and production support
  • Experience in server configuration, upgrades, patches, space management, database security, database design, management plan configuration, database scripting and documentation.
  • Experience in installing, maintaining, configuring and tuning SQL Server on Windows and Linux server environments
  • Experience in security management, process management, backup and restore management. Performance monitoring, turning and optimization.
  • Experience in designing, configuring and managing databases using either T - SQL or power shell
  • Flexible, team player, “get-it-done” personality.
  • Ability to organize and plan work independently.
  • Ability to work in a rapidly changing environment.
  • Ability to multi-task and context-switch effectively between different activities and Teams
  • Ability to Provide 24x7 support for critical production systems.
  • Ability to assist developers with complex query tuning and schema refinement.
  • Ability to research and has issues resolved faster

PROFESSIONAL EXPERIENCE

Sr SQL SERVER DBA

Confidential, WASHINGTON

Responsibilities:

  • Created views on a table or selected tables for specific purposes, in order to simplify database schema complexity to a none IT person, particularly for application users
  • Created triggers and store procedures for security and process management
  • Designed and implemented automatic Backup and Restore Strategies
  • Performed Performance Bottleneck Analysis using SQL Profiler, DTA, Query Execution Plans,
  • Tuned SQL Server performance in virtual environments (VMWare) with various SANs
  • Proactively monitoring databases to ensure high performance and high availability
  • Created after or instead of triggers to monitor any insert, delete and update on certain tables in addition to logon triggers on the server to monitor login security or activities
  • Worked on various DBA tasks including patching, cloning and upgrades
  • Performed database security management on both database and network levels
  • Performed installation SQL server and configuration of SQL Server database objects
  • Extensive experience in installing and implementing SQL Server Management and data tools
  • Hands on experience in the configuration of single instance and multi node SQL Server Infrastructure
  • Recommend solutions by defining database physical structure and functional capabilities, database security, database back-up, and recovery specifications
  • Maintain database performance by evaluating the size of databases, server operating systems and hardware products
  • Identify database requirements by interviewing customers, analyzing applications, programming, and operations. Evaluating existing systems and designing proposed systems requirements
  • Maintain professional and technical noledge by attending educational workshops, reviewing professional publications, establishing personal networks
  • Contributing to team effort by accomplishing related results as needed.
  • Deploying databases at every stage of deployment, ranging from development, testing, staging and production environment, Also Carried out version control process
  • Administer databases in both development and production environment
  • Transforms and loads data into database using SQL Loader or ETL process in SSIS
  • Supports the development team on application development and deployment
  • Work on physical data modeling and updates physical data models based on logical model changes
  • Perform in place and side by side migration of databases from SQL server 2008 to 2016

Jr SQL SERVER DBA

Confidential Arlington VA

Responsibilities:

  • Worked with team to ensure appropriate hardware resources are allocated and work with users to develop and optimize their SQL Server queries
  • Designed and perform various disaster recovery procedures and database maintenance
  • Created documentation and training plans for staff and end-users
  • Performed various standard DBA tasks. create, update, drop and delete databases and database objects, when necessary
  • Participated in the design and development of ETL Jobs using SQL Server Integration Services (SSIS) for data migration between different maintenance systems
  • Worked on scheduling data loading and transformations using SQL Server Integration Services (SSIS) between different maintenance systems
  • Assists the technical solutions team with testing and implementing technical enhancements to the site, tools for task tracking, version control, and other operational support areas.
  • Provisioning permission to users and developers on specific database as needed
  • Served as liaison with outside IT offices regarding database matters.
  • Worked with other DBAs to implement physical data models in database.
  • Synchronizes physical data model and database implementation
  • Designed complex SSAS solutions using multiple dimension perspectives, hierarchies. Measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers

Hire Now