03 Jul
SQL Database Administrator
Colorado, Denver , 80203 Denver USA

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

Report job