drjobs Sr Senior Database Administrator

Sr Senior Database Administrator

Employer Active

The job posting is outdated and position may be filled
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

USA

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Job Description

Position: Sr Senior Database Administrator/Architect
location: Remote (EST/CST only)
Duration: 6month contract (with possibility of conversion)
Interview mode: Virtual (2 rounds)
Job Description:
Short Term :
Review & propose.
1. Schemas and database server in the queries being executed.
2. Propose solution for SQL long queries.
3. SQL queries to improve performance.
4. Monthly Reports solutions for all equipment at customer level.
5. Design database structure for planned projects like file Management and Smart Tag.
6. Optimize Queries Ensure that queries are properly optimized.
7. Tables and create indexing. Ensure that tables are indexed on columns frequently used in WHERE clauses JOIN conditions and ORDER BY clauses.
8. Adjust database configuration parameters (such as memory allocation cache sizes and connection limits) to match the hardware resources and workload of our system.
9. Add partitioning and sharding to distribute load if required.
10. Large tables consider partitioning them based on certain criteria (such as range or hash partitioning).
11. Evaluate database schema and consider normalizing or denormalizing it based on the Current KC requirements.
Long Term :
Reporting Strategy
1. Purpose reporting tool for automated report and dashboard.
2. Establish a reporting cadence that provides timely insights without overwhelming stakeholders.
3. Balance frequency with the availability of relevant data and the need for realtime decisionmaking.
4. Explore various reporting tools available in the market. Consider factors such as functionality ease of use scalability cost integrations with existing systems and support for data visualization.

Employment Type

Remote

Company Industry

Key Skills

  • Databases
  • SQL
  • High Availability
  • PL/SQL
  • Solaris
  • Microsoft SQL Server
  • Database Design
  • Performance Tuning
  • MySQL
  • Shell Scripting
  • Database Administration
  • Oracle

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.