Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #2008

MS SQL DBA

Show all headers | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next | Find similar

Thread

MS SQL DBA nitya.recruiter4@gmail.com - 2018-11-08 03:13 -0800

csiph-web