Sr Specialist Database Administration

Job Description:

Job Description -

This position is responsible for application and system database administration, which includes the development and design of databases that support application and system. Database configuration, performance, reliability, recoverability, and maintaining and upgrading database software and related components. Operational database support for various DBMS software levels, versions, and operating systems.  Ensuring availability, performance, integrity, security, and confidentiality of databases, managing backups and recoveries, analyzing and resolving problems, managing disk space, applying patches and upgrades, and working with database vendor support. Developing and implementing best practices and standards, SQL tuning, automation, and project implementation activities.

Requires 5-8 years of experience.

Deep technical knowledge and subject matter expert.

Skillset for DBA

• SQL Programming (SQL queries, stored procedures, functions, and triggers)
• Proficiency in systems like Oracle, MySQL, PostgreSQL, SQL Server, NoSQL, MongoDB, and DB2
• Experience in Relational and Non-Relational DBMS
• Knowledge in database schema design, normalization, and indexing.
• Expertise in backup strategies, disaster recovery, and high availability solutions.
• Skills in optimizing database performance, query tuning, and monitoring.
• Implementation of security protocols, encryption, and access control measures
• Creating, implementing, and maintaining disaster recovery plan
• Familiarity with various OS like Windows, Linux, and Unix.
• Configuring alerts for proactive management.
• Proficiency in scripting languages such as Shell, Python, Perl, or PowerShell for automation.
• Knowledge of Azure Services.
  • DB infrastructure and management services
  • Proficiency in Azure SQL Database, including creation, configuration, and management.
  • Understanding of high availability, backup, and scaling on Azure services.
  • VM management.
  • Networking Configuration and Management
  • Familiarity with command line tools  
  • Azure resource monitoring. 
  • Familiar with ADO  
  • Familiar with Vertical and Horizontal Scaling
  • Proficiency in automating tasks using Azure Automation, PowerShell, and Azure CLI.
  • Experience in writing scripts for routine database tasks and incident response.
  • Setting up and using Azure Monitor, Log Analytics, and Application Insights for monitoring databases.
  • Expertise in tuning performance on Azure SQL Databases and Managed Instances.
  • Use of tools like Query Performance Insight and SQL Analytics.

Weekly Hours:

Time Type:

Location:

It is the policy of AT&T to provide equal employment opportunity (EEO) to all persons regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status, or any other characteristic protected by federal, state or local law. In addition, AT&T will provide reasonable accommodations for qualified individuals with disabilities.