Sr Senior Database Administrator
Sr Senior Database Administrator
Adame Services LLC
United States
See who Adame Services LLC has hired for this role
Position: Sr Senior Database Administrator/Architect
location: Remote (EST/CST only)
Duration: 6-month contract (with possibility of conversion)
Interview mode: Virtual (2 rounds)
Job Description
Short Term :
Review & propose.
Reporting Strategy
location: Remote (EST/CST only)
Duration: 6-month contract (with possibility of conversion)
Interview mode: Virtual (2 rounds)
Job Description
Short Term :
Review & propose.
- Schemas and database server, in the queries being executed.
- Propose solution for SQL long queries.
- SQL queries to improve performance.
- Monthly Reports solutions for all equipment at customer level.
- Design database structure for planned projects like file Management and Smart Tag.
- Optimize Queries - Ensure that queries are properly optimized.
- Tables and create indexing. Ensure that tables are indexed on columns frequently used in WHERE clauses, JOIN conditions, and ORDER BY clauses.
- Adjust database configuration parameters (such as memory allocation, cache sizes, and connection limits) to match the hardware resources and workload of our system.
- Add partitioning and sharding to distribute load if required.
- Large tables, consider partitioning them based on certain criteria (such as range or hash partitioning).
- Evaluate database schema and consider normalizing or de-normalizing it based on the Current KC requirements.
Reporting Strategy
- Purpose reporting tool for automated report and dashboard.
- Establish a reporting cadence that provides timely insights without overwhelming stakeholders.
- Balance frequency with the availability of relevant data and the need for real-time decision-making.
- 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.
-
Seniority level
Mid-Senior level -
Employment type
Contract -
Job function
Information Technology -
Industries
IT Services and IT Consulting
Referrals increase your chances of interviewing at Adame Services LLC by 2x
See who you knowGet notified about new Senior Database Administrator jobs in United States.
Sign in to create job alertSimilar jobs
People also viewed
-
Junior Assistant Database Administrator
Junior Assistant Database Administrator
-
Database Administrator (Remote)
Database Administrator (Remote)
-
SQL Server DBA
SQL Server DBA
-
Database Administrator
Database Administrator
-
Database Administrator
Database Administrator
-
Database Administrator
Database Administrator
-
Database Administrator
Database Administrator
-
Database Administrator
Database Administrator
-
Database Administrator - Remote | WFH
Database Administrator - Remote | WFH
-
Database Administrator/Developer
Database Administrator/Developer
Looking for a job?
Visit the Career Advice Hub to see tips on interviewing and resume writing.
View Career Advice Hub