What are the responsibilities and job description for the Senior Sql Database Administrator position at TPI Global Solutions?
Responsibilities
- Administer Microsoft SQL Server environments (2012–2019) on HP physical and virtual servers running Windows Server (2012–2019).
- Manage data environments, modernize complex legacy SQL code, and support new development efforts.
- Organize and document data processes effectively.
- Design standards for physical data storage, access, maintenance, and security.
- Perform backup and recovery operations, configure database parameters, and prototype designs against logical data models.
- Define data repository requirements, data dictionaries, and warehousing needs.
- Optimize database access and manage resource allocation for performance and cost-efficiency.
- Attend and participate in assigned onsite project meetings.
- Report to the database manager, with possible direct reporting to the deputy director.
- Provide after-hours availability for planned activities and on-call support.
Skills Required
- Experience with standalone SQL Server installations, feature additions, and edition upgrades.
- Proficient with SQL Server Installation Center for maintenance tasks.
- Ability to comprehend, maintain, and rewrite complex SQL scripts and legacy processes.
- Strong SQL programming with efficient syntax, code review participation, and documentation practices.
Expertise in:
- DML, DQL, DDL, DCL
- SQL Server Integration Services (SSIS)
- Data normalization, aggregation, concurrency, and modeling
- JSON data interchange format
Security-focused development aligned with:
- NIST standards
- Microsoft Trust Center (Azure Compliance)
- Internal Departmental policies
Strong data modeling skills including:
- Logical, physical, and relational modeling
- ER diagrams, entities, attributes, cardinality
- Functions, views, and triggers
Experience with:
- Azure Cloud Services
- BLOB Storage
- SQL Data Tools
- SQL Reporting Services
- Amazon Web Services (AWS)
- Excellent communication, documentation, organizational, and analytical skills.
- Collaboration with project managers, designers, peer DBAs, and stakeholders for business rule discovery, application design, and process control implementation.
Experience Required
- 5–10 years of experience in database design, testing, implementation, maintenance, and administration across multiple platforms.
- Minimum 5 years as a lead Microsoft SQL Server Database Administrator.
Senior Mainframe Database Administrator (DB2)
Peraton -
Montgomery, AL
SQL Database Admin
TechNix LLC -
Montgomery, AL
DataBase Administrator
Optimize Manpower Solutions -
Montgomery, AL
