1. Forum
  2. Usenet
  3. COMP.DATABASES.MS-SQLSERV

  • MS SQL DBA

    From nitya.recruiter4@gmail.com@21:1/5 to All on Thu Nov 8 03:13:27 2018
    Title: MS SQL DBA
    Location: Columbus, OH
    Description:
    • Design and implement robust database administration solutions including resource management, security, backup and recovery, performance monitoring and tuning, data management and capacity planning.
    • Planning and implementing failover between database instances for High availability (Replication, Always-On, Mirroring)
    • Determines database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems.
    • Install and configure new SQL Servers. Installing, configuring and upgrading SQL server software and related products. Perform routine DBA activities & service requests.
    • Design and implement scripts for instance monitoring, maintenance, backup, cloning, etc. utilizing T-SQL, SSIS, Reporting Services and Analysis Services
    • Setup & configure Active/Passive SQL server Cluster environment for critical Databases.
    • Monitoring and analyze Databases for Lock Escalation, Deadlock, resource utilization by sessions, capturing long running SQL queries, fine-tuning SQL statements that better result in efficient SQL statements processing.
    • As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies.
    • Implement High Availability/Disaster Recovery utilizing various methods, such as mirroring, peer-to-peer replication, and clustering.
    • When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
    • Install and configure new SQL Servers & Configure SQL Server monitoring utilities to minimize false alarms.
    • Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO) .Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO).
    • Involved in migrating SQL Server 2000, 2005, 2008, and 2008R2 databases to SQL server 2012, 2014, and 2016 databases.
    • Performance Analysis and Production Support for Large (VLDB) and Complex Databases expertise
    • Working on tool like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance
    • Expertise in planning and implementing Database Security by creating users, Roles, and assigning permissions to them

    Thanks&Regards
    M.Preethi
    nitya.recruiter4@gmail.com
    recruiter@nityainc.com

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)