• Us Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 11th Feb 2021

Job Description – MS SQL-server DBA

Conduent is seeking a MSSQL Database Administrator (DBA) who’ll oversee the day-to-day operational aspects of application and infrastructure delivery. You’ll serve as a subject matter expert regarding the application of business objectives and alternatives for database administration. Your responsibilities will also include establishing operational objectives and work plans, and delegate assignments as appropriate.  Provide senior management with reviews/objectives to determine the success of operation/project. The successful incumbent will be Involved in developing, modifying and executing company policies that affect immediate operations(s) and may also have company-wide effect.

  Primary Duties as follows:

·         Perform physical and logical database administration functions as required for Application Sustain Services.

·         Assist in analyzing, performance tuning and maintain test and production databases.

·         Experience in database support in MS SQL Server environments.

·         Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, log shipping issues, connectivity issues, security issues etc.

·         Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.

·         Experience with High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.

·         Experience in implementing operational automation using scripts.

·         Experience with backups, restores and recovery models.

·         Propose database changes to ease monitoring and administrative effort.

·         Document and implement changes to databases via proper Change Management methodology.

·         Monitor and analyze database activity to proactively identify and prevent potential Incidents and recommend performance improvements.

·         Participate in situation management of incidents related to database operations.

·         Test and evaluate impact on Applications of new DBMS Software releases.

·         Ensure integrity of all database components, e.g. Table definitions, structure definitions, statistic and indexes status etc.

·         Report and remediate all security violations.

·         Familiar with tuning utilities and reports. For example SQL trace, System Monitor, Open Activity Monitor, and Database Engine Tuning Advisor etc.

·         Familiar with MS Service Pack patching procedure.

·         Capable of evaluating new RDMBS technology with the objective to improve the quality of database administrative tasks.

Minimum Requirements:

8+ years of SQL Server database administration and design.

Extensive T-SQL tuning experience.

Solid knowledge of Windows scripting.

UNIX scripting experience (Korn and Perl) a plus

Strong communication, decision making and interpersonal skills.

Strong organizational and time management skills.

Able to work under pressure and take responsibility during situation management