Required Skills

SQL Server DBA

Work Authorization

  • Us Citizen

  • Green Card

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 29th Jul 2021

JOB DETAIL

 

The successful candidate will be a self-starter, and requires a person who is detail oriented. Candidate must be able to work both independently and as a team member to produce on time results to meet all project deadlines.

Local candidates preferred. Currently remote but must be available onsite day 1.

Required Experience:
Experienced SQL Server DBA Consultant
• Must have 10+ years hands-on SQL Server Relational database administration experience in a large,
clustered SQL Server environment.
• 2+ years hands-on DB2 z/OS database administration experience in large partitioned environment.
• Lead DBA experience is essential.
• Ability to work in a fast-paced environment and handle multiple priorities.
• Provide technical Tier 3 support.
• Ability to work with multiple teams to coordinate and plan upgrades.
• Work with vendors to determine SQL Server database instance configuration for installation of vendor
application tools

Required Technical Skills Include:
• Installing, configuring, and upgrading SQL Server 2016.
• Performance monitoring and tuning of SQL Server 2016.
• Backing up and restoring of SQL Server databases.
• SQL Server stored procedures using Transact-SQL.
• Creating and maintaining complex DTS and/or SSIS packages, including error handling.
• Database backup and other routine maintenance using TSM/Spectrum
• Performance optimization including indexes and query analysis.
• Creating a Maintenance plan, including documentation, and implementation in a 24/7 production
environment.
• SQL Server clustering.
• Implementing SSL Authentication on the database server to help secure data
• Installing, configuring, upgrading and maintaining Sharepoint 2016
• Performance monitoring and tuning of Sharepoint 2016
• Backing up and restoring of Sharepoint 2016
• Adding managed service accounts (MSA) for Sharepoint 2016 content databases
• Monitors logs for anomalies
• Maintains server inventory
• Troubleshoots database and application related issues.
• Provides SQL Server counts for Microsoft licensing true-up and helps ensure BWC licensing is compliant.

Desired Experience/Technical Skills/Achievements include:
• Knowledge of Microsoft Windows platform – Windows 2008 & 2016 server, and networking, including
firewall, TCP/IP routing and security.
• Virtual Server / VMWare experience.
• Experience in creating and supporting OLAP cubes
• SQL Server database replication.
• SQL Server log shipping.

Required Interpersonal Skills include:
• Excellent communication skills.
• The ability and desire to collaborate with BWC staff DBA’s.
• Skill/ability to plan and coordinate upgrades
• Must work well with other IT departments, and respond quickly, effectively and professionally to requests.
• Ability to collaborate with other teams (e.g. server, applications, network) to complete tasks.
• Adherence to BWC and IT administrative policies, such as status reporting, documentation, and
attendance policies.

Company Information