SQL Database Administrator

SQL Database Administrator

21 Jul 2024
Colorado, Denver, 80203 Denver USA

SQL Database Administrator

Vacancy expired!

Role: SQL Database Administrator Role: Remote ( Candidate Must be Local) Duration: 1+ Yrs Maintains data storage and access by evaluating, designing and implementing company database[s]. I Maintains Backups and Restores and space utilization, identifies data sources. Database Development Activities to include

  • All Object creation
    • Tables
    • Table Views
    • Functions
    • Stored procedures

  • Stored Procedure Development and Maintenance
    • This will execute SQL, which is written in the stored procedure
      • Executes on the Database server, as an objectYou
        • Takes the load off of the Application server
          • Removes the process of SQL Code being passed from server to server
      • Performance Reviews of embedded SQL within application logic
        • Where is the best place for the SQL processes to execute
          • Where does the logic live
          • If it lives here, makes it much easier for tracking down issues and slowness
  • Tables
    • Indexing
    • Attribute (Field) creation and mapping
    • Data Type setting
  • Table Views
    • Subset the data in the main tables
      • For focused processing of data
  • Functions
    • Triggers
    • Object Packages (EX: SSIS)
    • Repeatable processing
  • ORM Model
    • Object Role model
      • Outside SQL hitting the db
        • Parsing is an issue especially when the bind variables are wrong or missing
  • Object synching across all environments
  • Optimization Tasks
    • Database optimization
    • Query optimization
    • Working with large databases/datasets
    • Index maintenance
  • Troubleshooting
    • Transaction locks
    • Process blocks
      • Deadlocks
    • Replication
      • High Availability Setup
        • Always On Availability
    • SSRS (Reporting Service)
      • Maintenance and synchronization of data
  • Performance Tuning
    • Active execution and monitoring of database performance, regarding query execution and throughput
    • Real Time changes to running queries for optimal performance
  • Architecture/Design
    • Design of the database structure and systems.
    • Analyze the needs of the business and produce the data structure to meet these needs
    • Data analysis
    • Determining effective data flow throughout the system
    • Designing the data infrastructure to effectively store the data for access.
      • From both internal and external sources
    • Regular audits of database structure and logs to maintain quality

ACI (Advanced Computing International) is a Global Technology Services, Products & Solutions Company focused on designing and delivering the next generation applications and digital experiences for businesses and consumers. We specialize in Big Data & Analytics, Digital Transformation, IT Service Management, Cognitive Solutions, Artificial Intelligence, IOT & Future Networks, DevOps, Enterprise Applications & Managed Infrastructure Services & Industry Specific Solutions.
Leveraging the insights gained from working on innovative solutions and disruptive technologies, ACI develops Solutions to enhance business performance, accelerate product & applications time-to-market, harmonize Consumer Experiences and streamline their business operations. ACI works with clients across different business sectors: Financial Services, Healthcare, Manufacturing, Hi-Tech, Media, Utilities, Public sector, Retail, Telecom, E-commerce & Logistics, and Higher Education. ACI s core DNA is built on Innovation and co-existence to build a collaborative ecosystem where companies and consumers win.

Related jobs

Job Details

  • ID
    JC44268510
  • State
  • City
  • Job type
    Contract
  • Salary
    $DOE
  • Hiring Company
    ACI Infotech
  • Date
    2022-07-21
  • Deadline
    2022-09-19
  • Category

Jocancy Online Job Portal by jobSearchi.