What are the responsibilities and job description for the SQL Server DBA/Architect in Hamilton, NJ position at Super Technology Solutions, Inc.?
SQL Server Expertise
- 8 years of SQL Server administration experience
- Expert knowledge of SQL Server 2019/2022
- Advanced T-SQL programming (stored procedures, functions, triggers, views)
- Query optimization and execution plan analysis
- Index design and optimization
- Database design and normalization (1NF through 5NF)
- SQL Server security and compliance
- Backup and recovery strategies
- SQL Server Agent and job scheduling
- Database maintenance plans
High Availability & Disaster Recovery
- SQL Server Always On Availability Groups
- Database mirroring and replication
- Log shipping
- Failover clustering
- Multi-region deployment strategies
- Backup and restore strategies
- Point-in-time recovery
- Disaster recovery planning and testing
Performance Tuning
- Query performance tuning and optimization
- Index tuning and maintenance
- Execution plan analysis
- Wait statistics analysis
- Blocking and deadlock resolution
- Resource Governor configuration
- Memory and CPU optimization
- I/O optimization
- Performance monitoring tools (SQL Profiler, Extended Events, DMVs)
Cloud Database Services
- AWS RDS for SQL Server (3 years)
- Cloud database security and compliance
- Cloud backup and recovery
- Cloud monitoring and alerting
- Cost optimization strategies
Data Migration
- Large-scale data migration experience (500GB )
- Conversion scripts experience
- ETL tools and processes (SSIS, Azure Data Factory, AWS DMS)
- Data validation and quality assurance
- Legacy database migration experience
- Network database to relational conversion
- Data mapping and transformation
- Migration automation and scripting
Scripting & Automation
- PowerShell scripting for automation
- T-SQL scripting
- Source code management, GIHUB
- CI/CD for database deployments
- Automated testing frameworks
Professional Experience (Must Have)
- 10 years of database administration experience
- 8 years of SQL Server administration
- 3 years of cloud database experience (Azure SQL or AWS RDS)
- Experience with large-scale data migrations (500GB databases)
- Experience with mission-critical systems (99.9% uptime)
- Led or participated in database modernization projects
- Experience with high-transaction environments (50K transactions/day)
- Experience with Agile/Scrum methodologies