KNS IT GROUP · 1 day ago

SQL Server Database Administrator/Developer

United States

Full-time

Remote

Senior Level

7+ years exp

Maximize your interview chances

Information TechnologyIT Infrastructure

Insider Connection @KNS IT GROUP

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Responsible for the development and maintenance of rdbms platforms and database objects and with data access control supporting OLTP or analytic software applications on at least one major rdbms platform.

Assumes sole ownership of SQL Server Database Administration activities including creating database’s and data objects and managing database access.

Assists in evaluating DBA monitoring and productivity tools.

Performs complex relational database management tasks for both development and production applications.

Assists in database tuning when applicable.

Identifies, documents, and tracks all database related performance problems assisting in their resolution.

Performs tasks to develop database and data object creation scripts and to automate data management alerts.

Collects data for Database monitoring metrics and reporting.

Assists in developing, gathering data for and reporting of metrics.

Develops database management skills and assists with the development of junior DBA’s.

Works on projects of moderate to high complexity within one or more development environments.

Works on multiple systems and rdbms platforms as a project team member.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

SQL Server AdministrationT-SQLDatabase Performance TuningDatabase SecurityDatabase Backup & RecoveryDatabase ArchitectureDatabase ManagementReplication TechnologiesDisaster Recovery ProceduresMonitoring Tools EvaluationJuniorDevelopmentOLTP SupportFault AnalysisDatabase Object Creation

Required

Bachelors Degree in Computer Science or related filed of study.

Minimum of 7+ years, post graduate, experience in the Administration of SQL Server Databases.

Minimum of 7+ years, post graduate experience as a SQL Server DBA in a shared services environment (i.e. environment where different teams manage various activities, including server management, database administration, network operations, storage, etc.)

3+ years of DBA experience in supporting application development teams in addition to production/operations.

3+ years of DBA experience in installations & optimization.

Hands-on experience in database administration and T-SQL usage.

Experience in large databases, supporting OLTP applications, and Replication technologies.

Database security and auditing.

Database architecture, including hardware configuration, logical and physical database layouts.

Database management, monitoring of multiple databases.

Database performance management and tuning.

Database fault analysis and resolution.

Database backup and disaster recovery procedures.