SQL Database Administrator

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