Senior Discovery Database Administrator, DBA
CGS Federal (Contact Government Services)
CloudMS SQL ServerSQL
Junior Database Administrator
Marshall Dennehey
full-time
Posted on:
Location Type: Hybrid
Location: Philadelphia • Pennsylvania • 🇺🇸 United States
Visit company websiteJob Level
Junior
Tech Stack
AzureMS SQL Server.NETSQLSSIS
About the role
- Oversee database development and modification efforts
- Primary IT support of Microsoft SQL Server and SQL databases
- Ensure data integrity and availability including monitoring and creation of backups and maintenance of High Availability server installations
- Database maintenance including sizing and provisioning, index maintenance and monitoring of logs and consistency checks
- Database design, tuning and troubleshooting for SQL applications
- Database administration for both relational and non-relational database systems
- Manage SQL Server databases inside Azure and other Data platforms
- User and database security management
- Installation and configuration of new SQL Server environments as required
- Research applicable technologies and solutions, evaluate products and make recommendations
- Work with software engineering teams to build solutions for relational and non-relational database systems
- Responsible for data integration and data transfer jobs using SSIS, DTS and other technologies as needed
- Assist with support of the Firm’s accounting system and related applications such as the data warehouse, conflicts, collections and time entry applications
- Assist IT and Finance personnel with complex database queries and financial reports as needed
- Maintain current and accurate knowledge of data storage and management best practices
- Develop and maintain documentation and standards
Requirements
- Can you commit to a hybrid work schedule, including mandatory weekly in-office presence at our Philadelphia location?
- Are you legally authorized to work in the United States without requiring visa sponsorship now or in the future?
- Are you available to complete a technical test within the next 2-3 days?
- Bachelor’s degree
- Working Knowledge of Microsoft SQL Server 2012 or later
- Understanding of SQL, including demonstrated ability to build SQL Servers, databases, backup and recovery plans, complex queries, integration packages (DTS/SSIS), views and stored procedures
- Knowledge of one or more reporting platforms including either Crystal Reports or SSRS
- Experience with PowerShell and/or .NET is a plus
- Proficient with Microsoft Office Suite
- Ability to provide high-quality documentation for technical systems; experience in building and/or maintaining standards and procedures
- Excellent / Exceptional verbal and written communication skills
- Excellent interpersonal skills: respectful and team-oriented, customer-focused, receptive to feedback and embracing continuous improvement
- Excellent customer service skills
- Excellent organizational skills and attention to detail
- Excellent time management skills with a proven ability to meet deadlines
- Strong analytical and problem-solving skills
- Ability to prioritize tasks and to delegate them when appropriate
- Ability to function well in a high-paced and at times stressful environment
- Exceptional work ethic: strong sense of ownership of personal and team work, doing what is needed without being asked and following through
Benefits
- Firm offers a sound future, competitive salary and an excellent benefits package.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
Microsoft SQL ServerSQLSSISDTSdatabase designdatabase administrationdata integrationdata transferPowerShell.NET
Soft skills
verbal communicationwritten communicationinterpersonal skillscustomer serviceorganizational skillsattention to detailtime managementanalytical skillsproblem-solving skillsteam-oriented
Certifications
Bachelor’s degree