SQL Database Administrator

General Trading Co.
Carlstadt, NJ, United States
24 days ago
Apply on www.indeed.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Job source

Tech stack

Computer Programming Databases Data Integration Data Integrity Data Loss Database Design Database Queries Database Security Disaster Recovery Microsoft SQL Server Standard Sql Software Engineering
+13 more
SQL Stored Procedures SQL Databases SQL Server Reporting Services SQL Server Integration Services SQL Server Analysis Services Transact-SQL Scripting Connectivity Problems Database Performance Indexer Information Technology Database Capacity Planning Database Backup

Job description

  • Install, configure, and upgrade SQL Server instances and related database components.
  • Monitor database performance and implement changes to improve efficiency and reliability.
  • Perform regular database maintenance tasks such as backups, restores, indexing, and integrity checks.
  • Manage database security by implementing access controls, encryption, and auditing.
  • Troubleshoot and resolve database-related issues, including performance bottlenecks and connectivity problems.
  • Collaborate with developers to optimize queries and support application development.
  • Develop and maintain documentation related to database configurations, procedures, and policies.
  • Plan and execute database capacity planning and disaster recovery strategies.

Requirements

  • Bachelor’s degree in Computer Science, Information Technology, or a related field.
  • Proven experience administering Microsoft SQL Server databases in a production environment.
  • Strong proficiency in T-SQL programming, including writing complex queries, stored procedures, and triggers
  • Strong knowledge of SQL language, database design, and normalization principles.
  • Experience with database backup, recovery, and disaster recovery planning.
  • Familiarity with performance tuning and optimization techniques for SQL Server.

Preferred Qualifications:

  • Experience with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis (SSAS)., The SQL Database Administrator utilizes strong analytical and problem-solving skills daily to monitor and optimize database performance, ensuring systems run efficiently and securely. Proficiency in SQL and database design principles enables the administrator to write complex queries, troubleshoot issues, and support application development teams effectively. Preferred skills like experience with SSIS, SSRS, and SSAS enhance the ability to develop comprehensive data integration, reporting, and analysis solutions. Knowledge of backup and recovery techniques is critical for safeguarding data integrity and minimizing downtime during incidents. Familiarity with automation tools and scripting languages helps streamline routine maintenance tasks and improve operational efficiency. Additionally, strong communication and collaboration skills are essential for

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com
Prepare application

Good distractions

Loading talks and stories from around this role…