Address: San Jose, CA 95110
Telephone: 901-207-8038
Email Address: smithassociates1725@gmail.com
Hours: Office Hours – 3:30 PM – 8:00 PM CST
Diagnose and optimize slow queries query profiling, execution plans, schema/index tuning. Identify and remediate database performance bottlenecks index strategy, parameter tuning, workload analysis. Design an archiving/purging strategy to reduce overall database size while maintaining data integrity and access needs. Establish/validate operational best practices monitoring, alerting, backup/restore, performance baselines. Plan and execute Aurora MySQL engine upgrades, including blue/green deployments to minimize or eliminate downtime.
********************************************************************************************
Position Title : Senior DBA
ATTENTION : ” $TOP PAY “(Interviewing Now)
********************************************************************************************
Location : San Jose, CA
Full time : DBA MySQL PostgreSQL
Salary : Competitive
(Onsite)
Summary :
– Diagnose and optimize slow queries (query profiling, execution plans,
schema/index tuning)
– Identify and remediate database performance bottlenecks (index strategy,
parameter tuning, workload analysis)
– Design an archiving/purging strategy to reduce overall database size while
maintaining data integrity and access needs
– Establish/validate operational best practices (monitoring, alerting,
backup/restore, performance baselines)
– Plan and execute Aurora MySQL engine upgrades, including blue/green
deployments to minimize or eliminate downtime
Required skills :
– Strong MySQL performance tuning experience (query plans, query
optimization, indexing, transactions/locking)
– Strong diagnostics toolkit (EXPLAIN/EXPLAIN ANALYZE, slow query log,
Performance Schema, cloud monitoring)
– AWS Aurora/RDS operations experience (blue/green, parameter groups,
replicas, failover behavior, maintenance windows)
– Experience designing retention/archival approaches for large datasets
(partitioning, rollups, offline storage, ETL as needed)
– Ability to document and execute change plans safely (runbooks, risk mitigation,
rollback strategies)
Prefered :
– Typically, 5-10 years of relevant experience is expected.
– Experience should include database design, implementation, and maintenance.
– Proficiency in multiple database management systems (e.g., Oracle, SQL Server).
– Strong understanding of performance tuning and optimization techniques.
– Familiarity with backup and recovery strategies is essential.
– Leadership experience or mentoring junior DBAs can be beneficial.
For consideration you must act now, send resume to
smithassociates1725@gmail.com. Sincerely,
Gerald Smith
*******************************************************************************************