Database Administrator with Database Design Expertise jobs in United States
cer-icon
Apply on Employer Site
company-logo

NetConnect Digital Agency ยท 1 month ago

Database Administrator with Database Design Expertise

positionUnited States
timeFull-time
remoteRemote
senioritySenior Level
date5+ years exp

NetConnect Digital Agency is seeking a highly skilled and motivated Database Administrator (DBA) with proven experience in database design to join their growing team. The ideal candidate will be responsible for the full lifecycle of databases, from design and implementation to maintenance, performance tuning, and security.

AdvertisingDigital MarketingProfessional ServicesSEOWeb Design

Responsibilities

Design, develop, and implement database schemas, tables, views, stored procedures, and triggers
Collaborate with developers and business analysts to understand data requirements and translate them into efficient database designs
Conduct data modelling and create entity-relationship diagrams (ERDs)
Optimize database structures for performance and scalability
Install, configure, and maintain database systems (e.g., MySQL, PostgreSQL, SQL Server)
Perform database backups and recovery procedures
Monitor database performance and troubleshoot issues
Implement and maintain database security measures, including user access control and data encryption
Apply database patches and upgrades
Ensure high availability and disaster recovery capabilities
Analyze database performance and identify bottlenecks
Optimize SQL queries and database configurations for improved performance
Implement indexing strategies and query optimization techniques
Conduct performance testing and capacity planning
Enforce data integrity and consistency through constraints and validation rules
Implement and maintain database security policies and procedures
Perform regular security audits and vulnerability assessments
Ensure compliance with relevant data privacy regulations (e.g., GDPR, CCPA)
Create and maintain comprehensive database documentation, including data dictionaries, schema diagrams, and operational procedures
Generate reports on database performance, usage, and security
Communicate effectively with non-technical stakeholders

Qualification

Database DesignMySQLSQL Performance TuningData ModelingDatabase SecurityBackupRecoveryCloud Database ServicesScripting for AutomationDatabase Automation ToolsProblem-SolvingCommunicationCollaboration

Required

Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience)
5+ years of experience as a Database Administrator with database design experience
Strong proficiency in MySQL relational database management systems (RDBMS)
Proven experience in database design, data modeling, and schema development
Solid understanding of SQL and database performance tuning techniques
Experience with database backup and recovery procedures
Knowledge of database security principles and practices
Familiarity with database monitoring tools and techniques
Excellent problem-solving and analytical skills
Strong communication and collaboration skills
Experience with Cloud database services (Azure SQL) is a plus

Preferred

Relevant certifications in database administration or design
Experience with scripting languages for database automation
Experience with database automation tools

Benefits

The benefits will be provided as per their employment terms and conditions.

Company

NetConnect Digital Agency

twittertwittertwitter
company-logo
NetConnect Digital Agency offers responsive web design, WordPress development, PPC management, SEO and digital marketing services.
dateFounded in 2008
location
Lancaster, Pennsylvania, USA
people-size11-50 employees
web-link
https://netconnectdigital.com/

Funding

Current Stage
Early Stage
Company data provided by crunchbase