What are the responsibilities and job description for the Sr SQL Server Funtional /Application DBA position at Bright Mind Solutions LLC?
LOCATION : 26th Street Madison Ave, New York (Onsite Role)
Only GC / USC
ALL CANDIDATES WILL BE TECHNICALLY SCREENED VIA AN AI BEFORE SUBMITTAL TO CLIENT.
MUST HAVE :
- Must have recent experience performing Level 3 support (The highest level Support).
- Must have a Minimum of 10 years conducting general database administration tasks (e.g. DB implementation, DB code deployments, DB backups, creation of DB user accounts).
- Minimum of 7 years experience working as a SQL Server DBA.
- Must have experience as an Functional & Application DBA.
- Must have at least 5 years administering database platform specific advanced features (e.g. clustering, encryption, logical / physical standby, ETL, replication) and performance optimizing server database servers and SQL code.
- Minimum of 5 years experience working in a SQL DBA Role with multiple databases and SQL development issues.
- Proficient in MS SQL Server 2014 - 2019.
Additional Requirements :
Job Description :
1) Writing and improving SQL Server T-SQL queries for at least a year. You will be known amongst the office as the go-to person for T-SQL questions.
2) Designing tables and picking datatypes Using Profiler traces and other tools to find the most frequently run queries.
3) Using free tools like sp_BlitzIndex and DMV queries to answer questions about index usage.
5) On-call troubleshooting for SQL Server service outages.
6) Deciding whether clustering, log shipping, mirroring, replication, etc are the right fit to solve a business problem.
Skills Need :
