Database Administrator

Tata Consultancy Services

Date: 10 hours ago
City: Las Vegas, Nevada
Salary: $95,000 - $115,000 per year
Contract type: Full time
SQL Server DBA

Must Have Technical/Functional Skills

  • 5+ Years SQL Server DBA
  • DAG (Distributed Avail Groups) – across to data centers
  • Data Warehouse experience
  • Must be onsite

Roles & Responsibilities

  • Must have 5+ years SQL Server DBA working experience with SQL Server.
  • Must be knowledgeable and experienced in the different versions of SQL Server (2012 - 2016). Knowledge of upgrading to SQL Server 2019 & 2022 and benefits to the migrating to these environments.
  • Must have skills and experience in Database data management – backups, ETL, and archive using native SQL Server backup tools.
  • Experienced using internal diagnostic and maintenance tools such as DBCC and internal SP functions as well as SQL Diag, SQL Profiler, and third-party diagnostics tools.
  • Demonstrate Knowledge of Partitioning Architecture.
  • Experienced in collaborating with data warehousing developers. Knowledge of BI toolsets including SSIS, SSAS, SSRS, and MS SharePoint.
  • Management of multiple processing schedules and notification strategies. Strong skills in T-SQL, DOS, PowerShell, tuning, and debugging. Experience with SQL Server Manager, Visual Studio, DTS/SSIS, and other SQL Server tools including but not limited to Profiler & SQL Server Command Line Utilities
  • Experience with SQL Server database replication and mirroring
  • Experienced in security/access strategies for a wide pool of user groups and developers with different access requirements.
  • Ability to maintain a positive attitude while working with high demands and short deadlines
  • Ability to prioritize heavy workload with minimum supervision
  • Highly adaptable with the ability to work in a fast-paced demanding environment
  • Must have excellent communication and interpersonal skills
  • Ability to work well with development and infrastructure teams in doing database design, changes, and enhancement to new and existing applications.
  • Strong organizational and analytical skills.

Understanding of High Availability and Disaster Recovery requirements and solutions.

Essential Job Functions

  • Apply All aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup, and recovery.
  • Work 24x7 rotational on-call support, including driving Root Cause Analysis (RCA), Preventative action follow-through, and participation in weekly operations reviews.
  • Change management including maintenance of multiple development, test, QA, and production environments. Responsible for de ploying approved changes to production.
  • Proactive database monitoring and issue resolution
  • Database and T-SQL optimization including performance tuning, query optimization, and supportability.
  • Actively participate and contribute to projects involving enterprise database systems enhancements to meet business requirements. Participate in project design and SQL Server database design decisions.
  • Develop and implement Database security policies and procedures, in line with corporate objectives
  • Responsible for evaluating patch releases and patching requests from development, and communicating constraints, issues, and timelines for deployment.
  • Implementation and ongoing support of high availability architecture standards and technologies.
  • Create and maintain appropriate documentation about the database and the data architecture.
  • Support data management solutions including ETL processing, data archive, data purge, etc.
  • Regular proactive capacity planning and tending reviews of all SQL Server databases. Producing weekly, and monthly management reports.
  • Work on project sizing processes - including design reviews as necessary to appropriately size new environments, recommend design strategies and deliver associated cost and resource effort estimates.
  • Perform other duties as assigned.

Salary Range- $95,000-$115,000 a year

Post a CV