Systems Products and Solutions, Inc. is seeking to add a Senior Database Administrator to our team.
SUMMARY: The Senior DBA position will be responsible for maintaining the customer’s database systems (currently MS SQL Server) including back-up, performance tuning, reporting, analysis, capacity planning, monitoring critical events and documentation.
AREAS OF RESPONSIBILITY AND DESCRIPTION OF DUTIES:
- Create and manage multiple databases and assist in capacity planning.
- Monitor, maintain database systems and troubleshoot problems that may arise.
- Maintain data integrity and security (manage roles and permissions of database users).
- Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them.
- Develop strategies and implement solutions for managing back-ups, restoration and replication.
- Create and manage constraints and indexes.
- Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures.
- Proactive housekeeping/archiving and shrinking of databases. Job Description Senior Database Administrator
- Manage production, QA and development database environments. · Create detailed documentation including diagrams of database infrastructure. · Learn relevant business processes and understand the data flow, criticality and dependencies.
- Effectively coordinate and communicate with all the stakeholders (internal teams and clients).
- Set up and maintain database infrastructure for the company’s BI needs.
REQUIREMENTS:
- Candidate must possess a minimum of eight (8) years of experience administering Microsoft SQL server databases (SQL Server 2012/2016).
- A Bachelor’s degree in a technical related field his strongly preferred.
- Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems.
- Experienced in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
- Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL.
- Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance.
- Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies would be an advantage.
SECURITY CLEARANCE: Candidate Must be a United States Citizen and possess a DoD Security Clearance at the level required.
SKILLS:
- Candidate will have a proven record of being able to work independently and multi-task to meet deadlines.
- Candidate will be organized and have an eye for the details.
- Must possess superb verbal and written communication skills.
- The Systems Administrator is responsible for client negotiations and will interface with internal and external senior management.
