Senior Database Administrator

Description
Company
SDI Presence LLC is an IT managed services provider (MSP) and consultancy that leverages its strong team presence to advance our clients to a secure digital enterprise. With a 20-year corporate resume, SDI delivers strategic managed services, IT consulting, and hybrid infrastructure solutions to optimize our clients' technology environments. SDI is a certified Minority Business Enterprise (MBE), with a portfolio of clients that includes some of the nation's largest airports, utilities, commercial real estate portfolios, and government agencies. SDI delivers a deep technical presence through a local delivery model to achieve customer confidence and success. Visit us at www.sdipresence.com and connect with us on Twitter and Instagram .
Although we list out what we generally look for in this job description, we are very likely missing other attributes and skills that you have that could make you a great fit but are not currently listed. The point we're getting at is it doesn't hurt to take a chance and apply!
Summary
The Senior Database Administrator will be responsible for the enterprise level SQL and Oracle Databases of SDI as well as for our clients. This encompasses on-prem and cloud database environments. performance tuning, Database High Availability design and implementation, and T-SQL, PLSQL/Perl/shell programming. The Database Administrator is responsible for tasks such as the development of best practices, repeatable procedures, as well as day-to-day database activities. This is a remote opportunity.
Responsibilities:

• Stand up scalable SQL and Oracle instance and databases from scratch for on-prem and cloud environments
• Secure the Databases using best practices such as at rest database encryption, strong authentication, user management and data access control
• Ensure high-availability of databases and use of disaster recovery solutions such as fail-over environment, partitioning, failover clusters, Oracle Real Application Clusters (RAC), use of caching, standard hard disk drives, solid-state drives, and ultra-disks.
• Ability to design and manage storage requirements for volume and performance
• Data Model planning and development with development teams
• Design, debug implement, and maintain stored procedures, triggers, and user-defined functions.
• Assists development team on optimizing and troubleshooting queries
• Create and manage database documentation
• Supporting Data Conversions teams with source data
• Working with multiple project implementation teams to support varying amounts of data needs
• Closely working with other DBAs, application administrators, development teams, and test teams to define requirements and develop solutions to complex problems
• Perform database upgrades to new release levels
• Monitor database activity for performance and security. Setup alerts and notifications.

Requirements:

• Strong experience with scripting for replicate, pump, and trail files
• Minimum 3 years of overall IT delivery of enterprise databases architecture projects such as SQL Server and Oracle database infrastructure design, builds, upgrades, migrations, support, and performance tuning database administrative experience
• Initial extracts/replicate from other databases such as DB2 for large data volume in millions of rows
• Implementing restart, logging, error handling and notification
• Support Data Conversion teams with source data
• Project implementation and experience supporting multiple teams with data
• Working with Oracle on SRs for critical issues
• Strong oral and written communication skills along with problem solving skills
• Understanding and working knowledge of service tickets, incidents in Azure DevOps, JIRA, and Service Now tools
• Intermediate knowledge of SQL Server T-SQL and Oracle PL/SQL and SQL including performance tuning, debugging, complex SQL queries, stored procedures, packages, functions, and cursors
• Experience as Oracle RAC DBA
• Experience with ExaCS is a plus
• Experience with ETL tools such as SSIS and Oracle Data Integrator is a plus

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.
COVID-19 Vaccine Statement
This position will be required to disclose their COVID-19 vaccination status.
Equal Opportunity Employer Statement
SDI Presence is an equal opportunity employer that is committed to diversity and inclusion in the workplace. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws.
This policy applies to all employment practices within our organization, including hiring, recruiting, promotion, termination, layoff, recall, leave of absence, compensation, benefits, training, and apprenticeship. SDI Presence makes hiring decisions based solely on qualifications, merit, and business needs at the time.
Staffing Firms
SDI Presence does not seek or accept unsolicited resumes or CVs from recruitment agencies. We are not responsible for, and will not pay, any fees, commissions, or any other payment related to unsolicited resumes or CVs except as required in a written contract between SDI Presence and the recruitment agency or party requesting payment of a fee.
Compensation Notice
Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $130k/year in our lowest geographic market up to $150k/year in our highest geographic market. Pay is based on several factors including market location and may vary depending on job-related knowledge, skills, and experience. SDI Presence LLC is a total compensation company. Dependent on the position offered, other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits.