clearAvenue, LLC
Database Administrator
clearAvenue, LLC, Albany, Georgia, United States, 31701
Database Administrator
Job Responsibilities:
Provide server and database support, including installation, patching, upgrading, and maintenance
Administer user access, provisioning, and de-provisioning in accordance with policy and procedures
Perform database maintenance such as indexing, statistics, backup and restore, performance tuning, full-text indexes, data archival, user access security, partitioning, and data compression
Creating, editing, and maintaining database schemas
Implement High Availability/Disaster Recovery utilizing various methods, such as mirroring, peer-to-peer replication, and clustering
Provide support by collaborating with systems analysts, developers, business analysts, and project teams
Install and maintain the performance of database servers
Develop processes for optimizing database security
Set and maintain database standards
Manage database access
Performance tuning of database systems
Install, upgrade, and manage database applications
Diagnose and troubleshoot database errors
Recommend and implement emerging database technologies.
Create and manage database reports, visualizations, and dashboards
Create automation for repeating database tasks
Be available for on-call support as needed
Job Qualifications and Requirements:
Strong command of SQL and SQL server tools
Advanced knowledge of database security, backup and recovery, and performance monitoring standards
Understanding of relational and dimensional data modeling
PowerShell and Unix shell scripting skills
Strong mathematical and statistical knowledge
Excellent written and verbal communication skills
Impeccable attention to detail
Education and Experience Requirements:
Preferred bachelor’s degree in computer science or a related field
Proven experience in database administration, information technology, database architecture, or a related field
Experience with Linux and Windows Server environments
Experience with database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB)
Preferred Oracle Certified Professional or Oracle 11g or higher
Preferred experience with Real Application Cluster (RAC)
Security + CE certified or ability to obtain within 60 days of hired date
Must be a US Citizen
Clearance Requirement: Interim secret security clearance
Other Duties
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.
Benefits:
Comprehensive benefits package including, but not limited to health, dental, vision, PTO, HSA, FSA, opportunities for bonuses, 401k match, and more.
clearAvenue, LLC is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or disability status, protected veteran status, or any other characteristic protected by law.
Job Responsibilities:
Provide server and database support, including installation, patching, upgrading, and maintenance
Administer user access, provisioning, and de-provisioning in accordance with policy and procedures
Perform database maintenance such as indexing, statistics, backup and restore, performance tuning, full-text indexes, data archival, user access security, partitioning, and data compression
Creating, editing, and maintaining database schemas
Implement High Availability/Disaster Recovery utilizing various methods, such as mirroring, peer-to-peer replication, and clustering
Provide support by collaborating with systems analysts, developers, business analysts, and project teams
Install and maintain the performance of database servers
Develop processes for optimizing database security
Set and maintain database standards
Manage database access
Performance tuning of database systems
Install, upgrade, and manage database applications
Diagnose and troubleshoot database errors
Recommend and implement emerging database technologies.
Create and manage database reports, visualizations, and dashboards
Create automation for repeating database tasks
Be available for on-call support as needed
Job Qualifications and Requirements:
Strong command of SQL and SQL server tools
Advanced knowledge of database security, backup and recovery, and performance monitoring standards
Understanding of relational and dimensional data modeling
PowerShell and Unix shell scripting skills
Strong mathematical and statistical knowledge
Excellent written and verbal communication skills
Impeccable attention to detail
Education and Experience Requirements:
Preferred bachelor’s degree in computer science or a related field
Proven experience in database administration, information technology, database architecture, or a related field
Experience with Linux and Windows Server environments
Experience with database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB)
Preferred Oracle Certified Professional or Oracle 11g or higher
Preferred experience with Real Application Cluster (RAC)
Security + CE certified or ability to obtain within 60 days of hired date
Must be a US Citizen
Clearance Requirement: Interim secret security clearance
Other Duties
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.
Benefits:
Comprehensive benefits package including, but not limited to health, dental, vision, PTO, HSA, FSA, opportunities for bonuses, 401k match, and more.
clearAvenue, LLC is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or disability status, protected veteran status, or any other characteristic protected by law.