Database Administrator
Tata Consultancy Services
Date: 2 weeks ago
City: Las Vegas, Nevada
Salary:
$95,000
-
$115,000
per year
Contract type: Full time
SQL Server DBA
Must Have Technical/Functional Skills
Essential Job Functions
Must Have Technical/Functional Skills
- 5+ Years SQL Server DBA
- DAG (Distributed Avail Groups) – across to data centers
- Data Warehouse experience
- Must be onsite
- 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.
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.
See more jobs in Las Vegas, NV