Be an early applicantLess than 25 applicants

Company

Peraton · 8 hours ago

Database Administrator

United States

Full-time

Remote

Mid Level

$104K/yr - $166K/yr

3+ years exp

Maximize your interview chances

Information TechnologyRobotics

Actively Hiring

No H1B

U.S. Citizen Only

Insider Connection @Peraton

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

Implement and optimizes the computerized database systems that support the Company's or client's ability to function on a daily basis.

Implement and maintains smooth operation and physical design of databases.

Conduct performance tuning of indexes and databases in general.

Reviews database design and integration of systems, provides backup recovery and makes recommendations regarding enhancements and/or improvements.

Maintain security and integrity controls.

Formulates policies, procedures, and standards relating to database management, and monitors transaction activity and utilization.

May develop stored procedures and/or triggers.

Administers a variety of database systems ,such as Microsoft SQL Server, and other Database Management Systems (DBMS).

Develop and enforces database administration and user standards and procedures; audits, modifies, and amends data in systems using SQL commands.

Oversee the scheduling of database projects, database and transaction log backups, notifications, and database replication between multiple SQL Servers and remote sites.

Assists Database Designers/Information System Analysts in the development and creation of SQL and Web-based databases and database systems.

Review technical designs, reports, documentation, and other materials produced by staff; creates and maintains high-level reporting systems using products such as Crystal Reports; researches and implements new database and online technology.

Create Oracle database form the DDL provided from Modern

Create Oracle indexes, data views, user functions, column indexes and stored procedures

Create SQL bulk inserts pgms to convert legacy data from flat files extracts

Create stored procedure to grant access to stored procedures

Validate data conversions

Execute Oracal database status function to verify database integrity

Develop conversion validation programs to verify all data was converted

Hardened SQL database security from vulnerabilities

Install and configure Oracle server instances

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.

OracleMicrosoft SQL ServerDatabase Management SystemsCreating Oracle indexesInstalling Oracle serversStored proceduresData viewsUser functionsColumn indexesSQL commandsDatabase securityDatabase integrityBackup recoveryPerformance tuning